Re: Q: Can you rollback a trigger?

> >>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.

Unless you are updating distributed databases without 2-phase commit, that is.

Graham Received on Sun Feb 11 1996 - 00:00:00 CET