Use of Savepoint/Rollback statements
Posted by: Blai Francés Perigüell
Date: August 16, 2005 05:19AM

Hello you all, first of all thank you for your help.

I've been reading the manual for these statements. Generally it says that you can set a savepoint and perform some sql statements and then, if so, perform a rollback, before commiting the transaction, to restore your database.

My point is: I want to be able to set a savepoint, at least some sort of savepoint, in a way that allows me to perform any sql statement. I want to be able to perform even commit statements. But then, if I reckon I should perform a rollback to that savepoint, I MUST be able to do so.
This would help me in using different scripts that update my database and that are all related. So if any script reports a failure I'm able to restore my database to the point previous to the use of the scripts.

Does anybody have an idea? How can I solve this?

Thanks a lot,
Regards.

Options: ReplyQuote


Subject
Written By
Posted
Use of Savepoint/Rollback statements
August 16, 2005 05:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.