1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-01086: savepoint never established

Discussion in 'SQL PL/SQL' started by artmast, Aug 21, 2010.

  1. artmast

    artmast Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    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.com are no help as they do not give an Action for some reason.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Post your code otherwise no one can help you.