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

User_H7I9VApr 25 2012 — edited May 11 2012
Hi All,
I am trying to insert records in a table through called procedure.Called procedure having PRAGMA .Calling procedure passing the value to called procedure through a for loop. When i am executing the calling procedure..its gives below erorr.

ORA-06519: active autonomous transaction detected and rolled back


Any idea how to fix this issue.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2012
Added on Apr 25 2012
4 comments
32,209 views