Re: Avoiding PL/SQL * NO_DATA_FOUND exception

Jon,

just enclose your 'select into' code in an exception handler:

begin

    select ... into ...
exception

    when no_data_found then

        null; -- or whatever else!
end;

"Jon" <jzuazoa_at_nexo.es> wrote in message news:aeuu6t$shu$1_at_unbe.sarenet.es...
> Hi,
>
> Developing a PL/SQL stored procedure, I would to avoid NO_DATA_FOUND
> exception but without having to do a SELECT COUNT(*) previously as I am
> afraid that this is consumes lots of resources. Is there any other way to
do
> this task ?
>
> Thanks
>
>
Received on Fri Jun 21 2002 - 05:24:10 CDT