Re: DDL Trigger on schema - capturing content
Date: Sat, 08 Mar 2008 22:26:51 +0100
> 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:
> 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.
Have you looked at
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#ADFNS012 in particular on ora_sql_txt ?
Maxim Received on Sat Mar 08 2008 - 15:26:51 CST