Skip to Main Content

Oracle Database Discussions

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!

FOR Update Compound Trigger

bobmaganApr 24 2013 — edited Apr 24 2013
On DB 11.2. I have created a FOR Update COMPOUND Trigger on my table like below:

CREATE OR REPLACE TRIGGER AUDU_ATTENDANCE
FOR UPDATE
ON ATTENDANCE
COMPOUND TRIGGER

I am now trying to include the specific columns I want checked for update but it doesn't seem to like this. I know you can do this with 'AFTER UPDATE' triggers, but that does not work for COMPOUND. Any other options?

CREATE OR REPLACE TRIGGER AUDU_ATTENDANCE
FOR UPDATE
OF ATT_COMMENT
ON ATTENDANCE
COMPOUND TRIGGER
This post has been answered by Tubby on Apr 24 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2013
Added on Apr 24 2013
2 comments
467 views