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

2014-10-21 11:35 GMT-03:00 nico torres <frasebook4_at_gmail.com>:

> That was quick, thanks a lot Iggy.
>
> 2014-10-21 11:32 GMT-03:00 Iggy Fernandez <iggy_fernandez_at_hotmail.com>:
>
> 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 172
>> E....)_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