Saturday, 4 February 2012

ORA-06519: active autonomous transaction detected and rolled back

ORA-06519: active autonomous transaction detected and rolled back

Cause: Before returning from an autonomous PL or SQL block, all autonomous transactions started within the block must be completed (either committed or rolled back). If not, the active autonomous transaction is implicitly rolled back and this error is raised.

Action: Ensure that before returning from an autonomous PL or SQL block, any active autonomous transactions are explicitly committed or rolled back. ----------------------------------------------------------------------- 06520 through 06529 reserved for Foreign function errors

No comments:

Post a Comment