Oracle ORA-01086:从未建立保存点
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/3538958/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle ORA-01086: savepoint never established
提问by NickJH
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".
SQL 执行错误,ORA-01086:保存点“LASTSAVE”从未建立 ORA-06212:在第 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 Oradoctordo not give any help (action) for this.
回答by Adam Butler
Could it be because you have committed - perhaps by calling some ddl?
可能是因为你已经提交了 - 也许是通过调用一些 ddl ?