Re: PL/SQL Newbie Question

From: John Chiu <johnymc_at_netscape.com>
Date: Sat, 11 Sep 1999 06:05:49 -0400
Message-ID: <37DA297D.2082B312@netscape.com>

you can try the following blocking structure in your pl/sql:

begin
 ..... your program codings

    begin

       select ......from..... etc
    exception

       when no_data_found then
               null; /* the program exit this block */

    end;
    your program codings continue here
exception

    your other exceptions check here
end;

good luck

John Chiu
johnc_at_relsol.com

rocko_at_cosmos.com wrote:

> I have a SELECT statement that returns 1 row in a procedure. I want to
> just set the variable that holds the column value to a space(' ') if
> the SELECT does not return a row (NO_DATA_FOUND) and go on with the
> logic. However when I get the NO_DATA_FOUND exception the procedure is
> exited. How do I prevent this?
>
> Thanks for your help..
> "Let us pass over the river, and rest
> Under the shade of the trees."
Received on Sat Sep 11 1999 - 05:05:49 CDT