Forum Stats

  • 3,784,126 Users
  • 2,254,894 Discussions
  • 7,880,699 Comments

Discussions

Rollback to savepoint is notworking in Remote procedure

2671064
2671064 Member Posts: 1
edited May 12, 2014 8:57AM in SQL & PL/SQL

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 [email protected];

And i am getting output as below.

Select * From [email protected];

         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.

Tagged:

Answers

This discussion has been closed.