after trigger Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: after trigger

  1. #1
    Join Date
    Sep 2000
    Chicago, IL


    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.

  2. #2
    Join Date
    Aug 2000
    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

  3. #3
    Join Date
    Jul 2001

    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width