is it possible to call a procedure (with commit and rollback statement) inside a trigger.
is it possible to call a procedure (with commit and rollback statement) inside a trigger.
Last edited by krishnaindia2007; 05-22-2008 at 04:32 AM.
try to use autonomous trigger for the purpose.
Yes,It is possible by using AUTONOMOUS_TRANSACTION.
Yes, You can call a procedure with commit from a trigger using autonomous transaction.
An autonomous transaction is an independent transaction that is initiated by another transaction.Autonomous transactions allow a single transaction to be subdivided into multiple commit/rollback transactions, each of which will be tracked seperately.If it is not properly handled it may lead to data corruption.