Re: Avoiding PL/SQL * NO_DATA

From: Pinto <ucanmailme_at_india.com>
Date: Fri, 21 Jun 2002 16:32:01 +0530
Message-ID: <aev162$fe1$1@news.mch.sbs.de>

do a
select 1 from dual where exists (your original query); this i guess is not very resource intensive. Pinto.

"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 - 06:02:01 CDT

Re: Avoiding PL/SQL * NO_DATA_FOUND exception