SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger on All_Objects?

sharpeJan 15 2007 — edited Jan 16 2007

I would like to create a trigger on All_Objects that checks the LAST_DDL_TIME for a hard coded list of Object_Names. Any time the LAST_DDL_TIME has changed I want to call an existing stored database procedure to send myself an e-mail alert that an object has changed.

Is this possible?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2007

Added on Jan 15 2007

10 comments

755 views