RE: ORA-01403: no data found in a TCPDump
- From: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- To: "frasebook4@xxxxxxxxx" <frasebook4@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Oct 2014 07:32:18 -0700
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@xxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
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....)@.@.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
Other related posts:
