Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2008

    Unanswered: ORA-01086: savepoint never established

    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 do not give any help for this.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You have tables, data, SQL & error message & can not debug the problem.

    Why do you give us only error message & expect us to debug code we can not see?

    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version;

    I don't know what you have.
    I don't know what you do.
    I don't know what you see.
    It is really, really, REALLY difficult to fix a problem that can not be seen.
    use COPY & PASTE so we can see what you do & how Oracle responds.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Provided Answers: 23
    And most importantly: Show us the code where you set the savepoint.

    Just a shot in the dark: are you running in autocommit mode?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts