Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Insert & Update triggers fire together when a new record is created.
Hi,
I have two triggers, one when an insert is performed and the other when an update is performed. I use these triggers to synchronize two billing systems. So when a new account is created I update a temp table with a tag of 'NEW' and when a account is modified I send it with a tag of 'CHG'. But I create a new record both of the triggers fire and I get both the tags 'NEW' and 'CHG' in my temp table. Is there a way I could avoid this only when I am creating new accounts. I would be grateful if someone could help me. Thanks in advance.
Thanks
Yogi
Received on Fri Dec 27 2002 - 06:22:14 CST