SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rollback from within a SQL Update script

599838Sep 25 2007 — edited Sep 26 2007

Hi,

I have a very standard scenario to work on.

I have a master SQL Script that in turns call other SQL Scripts from within.

My question is, if say I have 5 scripts being called from within the master script and one of my scripts fail, then how do I write my master script so that it roll backs the updates done by the scripts executed before the failed script.

The scripts being called are update scripts like alter table

Hoping for a quick response

-AV

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2007

Added on Sep 25 2007

6 comments

1,090 views