Saai,
Thanks for your interest in this problem.
I tried savepoint and rollback, but could not think of a way to achieve a solution to the problem here.
The condition is as below.
Savepoint A; some code
Savepoint B; some code;
Savepoint C;
Now commit rollback from Savepoint A to B and commit from B to C.
Please suggest me if you can think any logic to achieve this...
debi148
Last Activity: Feb 9 '09, 04:12 AM
Joined: Feb 20 '08
Location:
-
-
Hi All,
I am very sorry to everyone who read or is reading the above piece od code snippet provided by me.
At line 34, by mistake I have updated the wrong statement. The right one is
-- Need to have some arrangement built around this t12() and t13() to commit
-- the changes. But changes by t11() need to be rolled back.
So the code snippet looks as below.
...Code:A sample piece of
Leave a comment:
-
Hi Sir,
Thank you very much for your help and the piece of inforamtion. But I need a bit more help regarding my problem.
What I understood from other sources is PRAGMA AUTONOMOUS_TRAN SACTION can be applied at single procedure level.
But for me the portion that I need to commit is in terms of multiple stored procedures. And since multiple processes access that, I cannot touch those procedures. But for...Leave a comment:
-
Can I commit portion of transaction in Oracle 9i?
Hi,
I am using Oracle 9i. I am using DML's only. Here I am inserting and updating some records upto say savepoint a. Then I insert and/or update few more records say upto savepoint b. The savepoint b returns some error like, 0, 1, 2, 3.
My requirement is I need to check the error. If it is 0, I need to commit from start to savepoint b.
If it is 1 or 2, I need to rollback from start to savepoint b.
...
No activity results to display
Leave a comment: