Re: [Q/H]: Exception handlers in PL/SQL
Date: 1 Mar 1994 07:22:46 -0600
Message-ID: <CLzI4C.JML_at_uk.ac.brookes>
Neil Greene (neil_at_kynug.org) wrote:
: I have a cursor that evaluates insert conditions for each record in a
: table. However, some records may not meet the requirements of the table
: restraints when the cursor attempts to complete various inserts, causing
: the cursor to "wig" out with either an unhandeled exception error or some
: other problem.
: I am familiar with the exception error handlers and with exception
: "others". But, how can I get the exception handler to simply trap any
: errors and move the cursor to the next available record with a
: fetchrecord. All I want to do is skip the current record and move on to
: the next one.
Some variation on:
EXCEPTION WHEN OTHERS THEN
NULL;
or set a flag to test etc.
-- Steve Corbett. vvv [. .] "just one person's opinion" p0070623_at_brookes.ac.uk -------o00-(_)-00o---------Received on Tue Mar 01 1994 - 14:22:46 CET