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 -> Re: NO NO_DATA_FOUND ?!?!

Re: NO NO_DATA_FOUND ?!?!

From: Martin Drautzburg <drautzburg_at_altavista.net>
Date: 06 Jun 2001 21:40:49 +0200
Message-ID: <873d9dpfb2.fsf@altavista.net>

Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de> writes:

> If a "select noex from dual" catches the no_data_found exception it
> purely says "no rows found". This is the way the no_data_found is
> handled by the sql engine that executes the select.

That's what the orinal poster and myself understand. The orignal poster had a problem with NO exception being raised even though no rows were found. I found this hard to believe, because the posted code did indeed raise an exception when I tied it. Received on Wed Jun 06 2001 - 14:40:49 CDT

Original text of this message

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