On Avoiding Termination

March 30, 2009

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