dcsimg

On Avoiding Termination

March 30, 2009

[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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers