Re: Recovering from an exception?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 1 Apr 1999 20:47:51 +0100
Message-ID: <922996290.8378.0.nnrp-09.9e984b29@news.demon.co.uk>

begin

{your chunk of code}
exception

when no_data_found then

{the response you want to make} end;

You can refine this by putting a loop, or simple two-step around the chunk, or
having two option

What to do if data is found in the main body and
What to do if no data is found in the exception

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Brian wrote in message <922995462.814.57_at_news.remarQ.com>...
>How do I recover from an exception so that a stored procedure doesn't
>terminate?
>I would like to catch the exception 'NO_DATA_FOUND' and be able to continue
>the procedure without it terminating.
Received on Thu Apr 01 1999 - 13:47:51 CST