Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06519:Active autonomous transaction detected and rolled back : Error
ORA-06519:Active autonomous transaction detected and rolled back : Error [message #136791] Sat, 10 September 2005 05:58 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
This msg automatically comes twice as my session hangs the first time
----------------------------------------------------------------
hi all,
in one of my procedure i am using pragma autonomous transaction.
And while testing this procedure i am getting the following error :

ORA-06519:Active autonomous transaction detected and rolled back

How i can solve this error.

Thanks And Regards
Dinesh

[Updated on: Sat, 10 September 2005 06:05]

Report message to a moderator

Re: ORA-06519:Active autonomous transaction detected and rolled back : Error [message #136796 is a reply to message #136791] Sat, 10 September 2005 07:14 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
ORA-06519 active autonomous transaction detected and rolled back

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.


is this the problem with your procedure.

did u run an explicit commit or rollback in your procedure?

regards,
tarun

[Updated on: Sat, 10 September 2005 07:15]

Report message to a moderator

Re: ORA-06519:Active autonomous transaction detected and rolled back : Error [message #136798 is a reply to message #136796] Sat, 10 September 2005 07:57 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Thanks tarun,
I got the point,each autonomous procedure will require an explicit commit or rollback..

Thanks and regards
dinesh
Re: ORA-06519:Active autonomous transaction detected and rolled back : Error [message #264547 is a reply to message #136798] Mon, 03 September 2007 13:20 Go to previous messageGo to next message
srinivasocp
Messages: 91
Registered: December 2005
Location: INDIA
Member
Hi ,

Can any one tell me,what
Quote:
each autonomous procedure will require an explicit commit or rollback
mean?


Thanks
Srini..
Re: ORA-06519:Active autonomous transaction detected and rolled back : Error [message #264553 is a reply to message #264547] Mon, 03 September 2007 13:49 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you use an autonomous transaction procedure then you have to commit or rollback before returning the parent transaction, to the caller.

Regards
Michel
Previous Topic: grant option does not exist
Next Topic: wanted SELECT Quesry to restrict count of the user selecting the record
Goto Forum:
  


Current Time: Wed Dec 07 02:48:10 CST 2016

Total time taken to generate the page: 0.24359 seconds