A quick Q about 'after' trigger:
If there is an insert into tableB 'after' trigger on a insert on tableA: and the trigger insert into tableB fails, does the insert into tableA rollback ??? Thus being depended on successful executing of the trigger.
triggering event must be successful in this case, or the trigger code does not execute.
[Edited by kmesser on 07-09-2001 at 06:38 PM]
Oracle DBA and Developer
A quick Q about 'after' trigger
U r doubt is table b has after insert trigger and in that trigger u r inserting a record in table a and if the insert in table b fails what will be the insert in table a.
Oracle fries After insert trigger only after the insert stmt is sucessful. So if the insert fails then the trigger won't be execute.
I hope i cleared u r doubt.
Click Here to Expand Forum to Full Width