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.