File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Head First Android this week in the Android forum!
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: 1771
    
  12

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
 
It's not a secret anymore!