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-26504: operation not implemented

1 Answers  


ORA-16554: translation not valid

1 Answers  


DRG-10853: Catsearch does not support this operator

1 Answers  


SQL*Loader-00488: %s not a named collection type for filler field string

1 Answers  


NPL-00313: requested form string does not match actual form string

1 Answers  






RMAN-06090: error while looking up controlfile copy: string

1 Answers  


ORA-14450: attempt to access a transactional temp table already in use

1 Answers  


ORA-28113: policy predicate has error

1 Answers  


ORA-00702: bootstrap verison 'string' inconsistent with version 'string'

1 Answers  


ORA-19768: USING clause only valid with ENABLE CHANGE TRACKING

1 Answers  


ORA-24078: cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL

1 Answers  


PCB-00631: Host variable is not an External LOB

1 Answers  


Categories