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.
But if it is 3, I need to rollback only from start to savepoint a. But the portion of transactions from savepoint a to savepoint b need to be committed.
I am not able to think how to acomplish the third condiotion, i.e, when the error type is 3.
Can anyone help me regarding this. Thanks a lot in advance.
Debi