| ORA-06519:Active autonomous transaction detected and rolled back : Error [message #136791] |
Sat, 10 September 2005 05:58  |
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  |
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
