Hi Team,
i am confused when use an "pragma autonomous_transaction". Don't know how to handle with this. pls share. why it is creating mutating error and how to resolve with different ways.. if i use "pragma autonomous_transaction" in the trigger statement. it's shows same error mess. pls help me.
Even i added the "pragma autonomous_transaction" in the statement why it is throwing the error mess?
Example:-
create or replace trigger T1
after insert on T2
declare
pragma autonomous_transaction;
begin
insert into t2 values(1);
end;
TRIGGER T1 compiled
insert into t2 values(2);
Error:-
00036. 00000 - "maximum number of recursive SQL levels (%s) exceeded"
*Cause: An attempt was made to go more than the specified number
of recursive SQL levels.
*Action: Remove the recursive SQL, possibly a recursive trigger.
Thanks.