Re: pl/sql coding help

From: <andrewf_at_jaredgroup.com>
Date: Thu, 11 Feb 1999 16:23:22 GMT
Message-ID: <79v05i$2b8$1@nnrp1.dejanews.com>

Put the Select into its own block, like the following,

begin
  Select ...
exception
  When ..
    Null;
end;

After Oracle handles the exception, it will continue at the statement right after the block.

In article <79t7sh$6dj$1_at_sloth.swcp.com>, elufker_at_swcp.com (Ed Lufker) wrote:
> Hi All:
>
> Does anyone have any examples of trapping the ORA-01405 error and
> just continuing after the error happens. This procedure runs in batch and
> when I get a no rows found the procedure exits. Below is the code:
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 11 1999 - 10:23:22 CST