DDL Trigger on schema - capturing content

I'm using a trigger like so:
CREATE OR REPLACE
TRIGGER TRG_SCHEMA_CHANGES
 AFTER DDL ON "MYSCHEMA".SCHEMA To capture all schema changes to a table I made. I use these variables to capture some pertinent data:
ora_login_user;
ora_sysevent;
 ora_dict_obj_type;
ora_dict_obj_owner;
ora_dict_obj_name;

I put the above into fields of the table I made. Seems to work fine.

What I would like to know is, how do I capture the ddl statement itself? I'd like to put the DDL statement itself that fired the trigger into a clob/blob field. Received on Sat Mar 08 2008 - 13:56:54 CST