DDL Trigger on schema - capturing content
Date: Sat, 8 Mar 2008 11:56:54 -0800 (PST)
I'm using a trigger like so:
CREATE OR REPLACE
AFTER DDL ON "MYSCHEMA".SCHEMA To capture all schema changes to a table I made. I use these variables to capture some pertinent data:
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