Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Database Trigger not fireing In Delete Mode
RE: Avoding Mutation of Table triggerHi all,
I have row level table trigger to fire on DELETE or INSERT or UPDATE Mode . It has to fire on certain condition, meaning I have a WHEN condition also.
WHEN Condition is like :
when ( NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not null )
Since, in DELETE mode NEW value contains null , it does not fire.
This Problem would have solved if could write WHEN Condition as
when ((INSERTING or UPDATING) and NEW.CR_ACCOUNT is not null and NEW.CHQ_DT is not null ) OR (DELETING and OLD.CR_ACCOUNT is not null and OLD.CHQ_DT is not null )
But in WHEN condition one can not write INSERTING or UPDATING.
How do i go about it ? Any round about way ?
Thanks & Regards.
Naba
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: N J Neog
INET: njneog_at_oil.asm.nic.in
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 10 2002 - 23:13:27 CDT