FOR Update Compound Trigger
bobmaganApr 24 2013 — edited Apr 24 2013On 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