wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes ORA-01086: savepoint never established Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORA-01086: savepoint never established" Watch "ORA-01086: savepoint never established" New topic
Author

ORA-01086: savepoint never established

Art Masterton
Greenhorn

Joined: Aug 21, 2010
Posts: 1
I am trying to set a savepoint and the rollback to that point when I have a problem. But I get the following message:

"SQL execution error, ORA-01086: savepoint 'LASTSAVE' never established ORA-06212: at line 1".

I have made sure there are no commits until then end but still get the error. I have also wrapped it up in a transaction.

Sites like Oradoctor are no help as they do not give any action.
Thanks!
Janeice DelVecchio
Saloon Keeper

Joined: Sep 14, 2009
Posts: 1660
    
  11

Are you maybe losing the savepoint by doing something that has an implicit commit?


When you do things right, people won't be sure you've done anything at all.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: ORA-01086: savepoint never established