Re: Q: Can you rollback a trigger?
From: PKelley772 <pkelley772_at_aol.com>
Date: 1996/02/10
Message-ID: <4finf6$c44_at_newsbf02.news.aol.com>#1/1
Date: 1996/02/10
Message-ID: <4finf6$c44_at_newsbf02.news.aol.com>#1/1
>>If I have a transaction, say in PL/SQL. During the transaction,
>>it fires up a number of triggers. Now, I rollback the transaction,
>>can all the triggers be rolled back? Always yes? Or no? Or is it
>>trigger dependent? Or should I need any special varible configure to
>>have it done?
In one of my systems, an insert into table 1 fires a trigger that causes
an insert into table 2, which fires a trigger that inserts into table 3,
etc.
Since I don't issue savepoints at any point in the transaction (not even
sure if it's legal in a trigger), a rollback will roll back all of the
inserts, every time.
Received on Sat Feb 10 1996 - 00:00:00 CET