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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Net & ORA-01403

RE: SQL*Net & ORA-01403

From: Billy Verreynne (JW) <VerreyB_at_telkom.co.za>
Date: Tue, 2 Aug 2005 09:27:31 +0200
Message-ID: <445F36B0271AE1419CEE0B9589044B433747C1@TYGRRA01-XCS00.telkom.co.za>

Brian Wisniewski wrote:

> Why the error msg but nothing popped to the screen - especially when
valid data is returned?

Brian, that's the resulting packet/response from Oracle when the eof of a cursor is reached.

E.g doing the last FETCH in PL/SQL does not return data. The cursor loop is then terminated via an EXIT WHEN C%NOTFOUND. That last FETCH results in a NO_DATA_FOUND response from the Oracle server session. But this is not treated as an exception by the client as it is expecting to hit the eof of that cursor sooner or later.

Run ethereal and sniff a SQL*Plus session to verify - pretty interesting stuff.

--
Billy

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 02 2005 - 04:32:53 CDT

Original text of this message

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