DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: after trigger

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Unhappy

    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
    Posts
    462
    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
    Posts
    8

    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
  •  


Click Here to Expand Forum to Full Width