Hi there,
I have several stored procedures, updating / inserting into several tables on an ORACLE 8i db in a specific order lets say procedures are 1 to 5.
In order for a complete update of the db I need all to run successfully, if any fail I want to rollback to the very start, that is if procedures 1-3 run successfully but 4 fails I want to take it all the way back to before procedure 1.
Currently they all reside in a package on the server and I intend to call them from a Powerbuilder client.
I have my exception / rollback included in each script but think that this will only roll back the current procedure not all of them, any ideas on how best to manage these rollback requirements ?
Many thanks,
Muly
I have several stored procedures, updating / inserting into several tables on an ORACLE 8i db in a specific order lets say procedures are 1 to 5.
In order for a complete update of the db I need all to run successfully, if any fail I want to rollback to the very start, that is if procedures 1-3 run successfully but 4 fails I want to take it all the way back to before procedure 1.
Currently they all reside in a package on the server and I intend to call them from a Powerbuilder client.
I have my exception / rollback included in each script but think that this will only roll back the current procedure not all of them, any ideas on how best to manage these rollback requirements ?
Many thanks,
Muly