4
Reply

Can we use commit in trigger?

James Tomar

James Tomar

10y
1.5k
0
Reply

    no.

    No

    yes

    Yes ,You can Commit inside the trigger.But for this you have to make this trigger transaction to be a Independent transaction from its parent transaction, You can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION allow you to build the Independent(child) Transaction,started by another. Should be declare in DECLARE section of any subprogram.