is it possible to call a procedure (with commit and rollback stmt) inside a trigger
is it possible to call a procedure (with commit and rollback statement) inside a trigger.
Re: is it possible to call a procedure (with commit and rollback stmt) inside a trigg
[QUOTE=rph.cap;30329]is it possible to call a procedure (with commit and rollback statement) inside a trigger.[/QUOTE]
A procedure called by a trigger cannot contain TCL commands.
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.
Re: is it possible to call a procedure (with commit and rollback stmt) inside a trigg
try to use autonomous trigger for the purpose.
Re: is it possible to call a procedure (with commit and rollback stmt) inside a trigg
[QUOTE=debasisdas;30341]try to use autonomous trigger for the purpose.[/QUOTE]
But it is not advisable to use.
Re: is it possible to call a procedure (with commit and rollback stmt) inside a trigg
Yes,It is possible by using AUTONOMOUS_TRANSACTION.
Re: is it possible to call a procedure (with commit and rollback stmt) inside a trigg
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.