Re: Q: Can you rollback a trigger?
From: Jack Jung <jjung_at_ca.oracle.com>
Date: 1996/02/08
Message-ID: <4fd1u3$oms_at_inet-nntp-gw-1.us.oracle.com>#1/1
Date: 1996/02/08
Message-ID: <4fd1u3$oms_at_inet-nntp-gw-1.us.oracle.com>#1/1
cswstang_at_cs.ust.hk (Tang Wai Shing Wilson) wrote:
>
>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?
If you are refering to database triggers, you cannot use COMMIT or ROLLBACK inside a database trigger, so a ROLLBACK or COMMIT from the procedure firing the trigger will also ROLLBACK or COMMIT all actions in the trigger. Received on Thu Feb 08 1996 - 00:00:00 CET