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.
A procedure called by a trigger cannot contain TCL commands.Originally Posted by rph.cap
Trying to call such a procedure from trigger will throw an error
ORA-04091: table SCOTT.Emp_tab is mutating, trigger/function may not see it.
Last edited by krishnaindia2007; 05-22-2008 at 04:32 AM.
try to use autonomous trigger for the purpose.
But it is not advisable to use.
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.
Posting Permissions
Reply With Quote