Click here to Skip to main content
15,921,028 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a function with some Savepoint in it as below
SQL
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

SQL
Exec TestRollToSave@R2link;


And i am getting output as below.
SQL
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.
Posted
Updated 12-May-14 22:25pm
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900