Sender: martin@beaureve
Newsgroups: comp.databases.oracle.server
Subject: Re: NO NO_DATA_FOUND ?!?!
References: <3B00E4E2.EB532A59@agora.pl> <871yp2qsgt.fsf@altavista.net> <3B1DD3AE.A4BB5BC0@0800-einwahl.de>
From: Martin Drautzburg <drautzburg@altavista.net>
Date: 06 Jun 2001 21:40:49 +0200
Message-ID: <873d9dpfb2.fsf@altavista.net>
User-Agent: Gnus/5.0803 (Gnus v5.8.3) XEmacs/21.1 (Capitol Reef)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Lines: 10
NNTP-Posting-Host: 213.7.11.40
X-Trace: 991853322 news.freenet.de 29845 213.7.11.40
X-Complaints-To: abuse@freenet.de


Martin Haltmayer <Martin.Haltmayer@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.