On Avoiding Termination

Monday Mar 30th 2009 by DatabaseJournal.com Staff

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

Mobile Site | Full Site