Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mutating error

user12114715Nov 10 2009 — edited Nov 10 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2009
Added on Nov 10 2009
7 comments
382 views