That was quick, thanks a lot Iggy. 2014-10-21 11:35 GMT-03:00 nico torres <frasebook4@xxxxxxxxx>: > That was quick, thanks a lot Iggy. > > 2014-10-21 11:32 GMT-03:00 Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>: > > 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 172 >> E....)@.@.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 >> > >