mutating error
i am writiing trigger.in that trigger if result coumn of table1 is updated to D i am creating new row in the same table1
CREATE OR REPLACE TRIGGER TEST
AFTER UPDATE OF result
ON table1
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
begin
IF :NEW.task_result = 'D'
THEN
TESTING ( );
end;
CREATE OR REPLACE PROCEDURE TESTING
aS
pragma autonomous_transaction;
BEGIN
INSERT INTO table1 values..
END;
i am getting this error
ORA-06519: active autonomous transaction detected and rolled back
ORA-04088: error during execution of trigger 'TEST'
how to solve it