FreeLists / oracle-l / RE: SQL*Net & ORA-01403

["Billy Verreynne (JW)" <VerreyB@xxxxxxxxxxxx>]

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