-
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
khussain,
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.
--Sriram.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|