Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Avoiding PL/SQL * NO_DATA_FOUND exception

Avoiding PL/SQL * NO_DATA_FOUND exception

From: Jon <jzuazoa_at_nexo.es>
Date: Fri, 21 Jun 2002 12:12:44 +0200
Message-ID: <aeuu6t$shu$1@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:12:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US