RE: SQL*Net & ORA-01403

Billy/Edgar - thanks for the information. It's interesting it uses the same code as a valid error to signal the eof - just wasn't expecting that.  

• Brian

"Billy Verreynne (JW)" <VerreyB_at_telkom.co.za> wrote:

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

		
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - Find what you need with new enhanced search. Learn more.
--
http://www.freelists.org/webpage/oracle-l