回滚到保存点在远程过程中不起作用 [英] Rollback to savepoint is notworking in Remote procedure

问题描述

我有一个带有一些Savepoint的函数，如下所示

I have a function with some Savepoint in it as below

Create Or Replace Procedure TestRollToSave
As
Begin
	Delete From TestQuote;
	Insert into TestQuote Values (111,'aaa');
	Insert into TestQuote Values (222,'bbb');
	savepoint a;
	Insert into TestQuote Values (333,'ccc');
	savepoint b;
	Insert into TestQuote Values (444,'ddd');
	Insert into TestQuote Values (555,'eee');
	Insert into TestQuote Values (666,'fff');
	savepoint c;
	Insert into TestQuote Values (777,'ggg');
	Rollback to b;
End;
/

我有另一个模式我在两个模式之间创建了一个链接，我通过以下链接调用此过程

And i have a another schema i have created a link between two schemas and i am calling this procedure through link as below

Exec TestRollToSave@R2link;

我得到的输出如下。

And i am getting output as below.

Select * From TestQuote@r2link;

         A B
---------- -------------------------------------
       111 aaa
       222 bbb
       333 ccc
       444 ddd
       555 eee
       666 fff
       777 ggg

表示回滚到保存点不是工作。



任何人都可以帮我解决这个问题。



我也没有收到错误。



有关更多信息，这两个模式在同一服务中。

但如果两个模式在不同的服务中，那么它工作正常。

Means the rollback to savepoint is not working.

Can anyone please help me to overcome this.

I am not getting error also.

For more information the two schemas are in same service.
But if the both schemas in different service then it is working fine.

推荐答案

这篇关于回滚到保存点在远程过程中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！