This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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

ORA-01086: savepoint never established

Art Masterton

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.
Janeice DelVecchio
Saloon Keeper

Joined: Sep 14, 2009
Posts: 1776

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.
Have you checked out Aspose?
subject: ORA-01086: savepoint never established
It's not a secret anymore!