On Avoiding Termination

Monday Mar 30th 2009 by DatabaseJournal.com Staff
Share:

Continue PL/SQL execution beyond exceptions.

[From OTN Oracle Magazine Technical Articles ]

I have been assigned the job of modifying an existing procedure that applies a complex set of rules to a large volume of data in a set of tables. In the past, as soon as an error occurred in an update, the procedure would terminate execution. Now I need to change the procedure so that it continues past any exceptions and completes as many updates as possible. What are my options in PL/SQL for doing this?

The article continues at http://www.oracle.com/technology/oramag/oracle/09-mar/o29plsql.html

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved