In this tutorial, you’ll learn everything about the error “ORA-06519: active autonomous transaction detected and rolled back” in Oracle, why this error appears and how you can resolve it in simple steps.
Oracle Error Message
This is how the Oracle error message ORA-06519 looks like in general.
ORA-06519: active autonomous transaction detected and rolled back
Reason for the Error
All autonomous PL/SQL block transactions that were started within the block must be finished before returning from it (either committed or rolled back). Otherwise, this error would be raised and the currently running autonomous transaction will implicitly be rolled back.
Solution
Ensure that before returning from an autonomous PL/SQL block, any active autonomous transactions are explicitly committed or rolled back. ———————————————————————– 06520 through 06529 reserved for Foreign function errors
