Skip to Main Content
Forums

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!

ORA-06519: active autonomous transaction detected and rolled back

634151Sep 7 2010 — edited Sep 7 2010
Hi,

I have a trigger and calling stored procedure from the trigger. That Stored Procedure contains COMMIT statements. So i used PRAGMA AUTONOMOUS_TRANSACTION in my trigger. i created the trigger to fire after insert into the table. When i try to insert the data, i am getting the below error.

ORA-06519: active autonomous transaction detected and rolled back

Can anyone clear or correct me.

Thanks
This post has been answered by 776343 on Sep 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2010
Added on Sep 7 2010
#11g, #9i, #database, #oracle, #pl-sql, #plsql, #sql, #table, #trigger
2 comments
10,979 views