RE: ORA-01403: no data found in a TCPDump

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Tue, 21 Oct 2014 07:32:18 -0700
Message-ID: <BLU179-W4926A107A1B7510D0B0DE0EB940_at_phx.gbl>

That's how Oracle signals that there are no more records left in a cursor. The last fetch will therefore result in an ORA-1403. Iggy

Date: Tue, 21 Oct 2014 11:18:48 -0300
Subject: ORA-01403: no data found in a TCPDump From: frasebook4_at_gmail.com
To: oracle-l_at_freelists.org

Hi list,
I Have a question for you today, I am curious about this. I issued for the first time a tcpdump on 3 or 4 (testing) databases, and found out that, after any login, and and any query, Oracle responds with an ORA-01403: no data found, besides the fetched data. Here is a sample, on a sqlplus login, after a bunch of data:

07:50:06.398051 IP dummyserver > dummyclient: Flags [P.], seq 3125:3297, ack 2348, win 177, options [nop,nop,TS val 3861719327 ecr 1961424219], length 172E....)_at_._at_.m...C...B..J...s.N................-).t..[......................{...........................................6................ .............................................................ORA-01403: no data found

Does anyone have any idea if this is an internal normal behaviour? Thanks

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 21 2014 - 16:32:18 CEST