ORA-06519: active autonomous transaction detected and rolled
back



ORA-06519: active autonomous transaction detected and rolled back..

Answer / guest

Cause: Before returning from an autonomous PL/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/SQL block, any active autonomous transactions are
explicitly committed or rolled back.
-----------------------------------------------------------------------
06520 through 06529 reserved for Foreign function errors

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07758: slemcw: invalid handle

1 Answers  


ORA-06933: CMX: error during attach

1 Answers  


ORA-29533: attempt to overwrite class or resource string while defining or compiling string.string

1 Answers  


ORA-02486: Error in writing trace file string

1 Answers  


ORA-30933: Element 'string' may not appear at this point within parent 'string'

1 Answers  






NNL-01051: Server name: string

1 Answers  


PCC-00082: Length and scale specifications must be an integer

1 Answers  


ORA-13509: error encountered during updates to a SWRF table

1 Answers  


ORA-04068: existing state of packagesstringstringstring has been discarded

1 Answers  


ORA-13303: failure to retrieve a geometry object from a table

1 Answers  


RMAN-06548: connected to auxiliary database: string (DBID=string)

1 Answers  


ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.

1 Answers  


Categories