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.