Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If I try to remove the final where statement the query runs fine.
Also if I try to "reduce" the rownum filter to a lower level of records the query runs fine:

where rownum<10

Searching on internet I have found that it could be caused by the parameter "cursor_sharing" to "similar" that seems buggy on some version of oracle. I tried to set it to "exact" but unfortunately I have the same error.

I was wondering if the retrieved data of a select statement may have a limit in bytes in oracle10g but I haven't found anything. I have found a limit on oracle8i but nothing to oracle10g.

We have the same problem executing the query on different client (dbvisualizer, squirrel) and on oracle console.

3 Answers
3

No more data from socket means that the shadow process crashed, with an
ORA-600 or ORA-7445, for example. Look for a trace file in the
user_dump_dest directory and/or an entry in the alert log. This is
likely a bug

That may be the case, but an error "No more data to read from socket" isn't the same as a query returning 0 rows, but some bug. On the other hand, maybe this condition is somehow triggering the error?
–
Colin 't HartJun 5 '14 at 13:36