My Oracle Support Banner

ORA-600 [HO Define: Long Fetch] (Doc ID 2270309.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

ORA-600 [HO define: Long fetch] when using an Oracle Database Gateway Product.  When performing an analysis on the logs and trace files,  it was clarified that the issue only occurs when using 3rd party tools like SQL Developer , Toad,  etc...  instead of SQL PLUS for particular queries.


Reviewing Document id : 1224783.1 a few points are important:
- The ORA-600 [HO define: Long fetch] occurs when select query is fired from 3rd party tools like PLSQL developer , Toad for oracle.
- This can happen from versions 11.1 to 12.1
- The ORA-600 can happen for several reasons, the root cause of the error with the third party applications depends on the table being selected. The table description contains 2 long or long raw columns , for example –
CURRENCEY DATA LONG RAW
MEMO LONG

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.