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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 21:20:49  来源:igfitidea点击:

Oracle ORA-01086: savepoint never established

oracle

提问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.

Oradoctor这样的网站不会为此提供任何帮助(操作)。

回答by Adam Butler

Could it be because you have committed - perhaps by calling some ddl?

可能是因为你已经提交了 - 也许是通过调用一些 ddl ?