Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > DDL Trigger on ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 6767 of 7279
Post > Topic >>

DDL Trigger on schema - capturing content

by Luch <DarthLuch@[EMAIL PROTECTED] > Mar 8, 2008 at 11:56 AM

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.
 




 4 Posts in Topic:
DDL Trigger on schema - capturing content
Luch <DarthLuch@[EMAIL  2008-03-08 11:56:54 
Re: DDL Trigger on schema - capturing content
Maxim Demenko <mdemenk  2008-03-08 22:26:51 
Re: DDL Trigger on schema - capturing content
DA Morgan <damorgan@[E  2008-03-08 16:36:53 
Re: DDL Trigger on schema - capturing content
Luch <DarthLuch@[EMAIL  2008-03-09 10:16:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 20:11:11 CST 2008.