Getting Ora-600 From User Session When Selecting a SQL-Server View With Only One LONG column
Last updated on JULY 06, 2017
Applies to:Oracle Database Gateway for SQL Server - Version 220.127.116.11 and later
Information in this document applies to any platform.
ORA-00600: internal error code, arguments: [HO define: Long fetch], , , , , , , , , , , 
Developer is using Microfocus COBOL to select a SQL Server table with only one LONG datatype, via oracle database gateway for SQL Server.
We also have been able to reproduce this with a simple C# program and a very small (3 row) SQL Server table which reproduces it consistently.
Additional information that we can provide. The sample program reproduces the problem in the following method:
1. Open connection to database.
2. Start transaction.
3. Open a cursor
4. Fetch rows till no more.
5. Close the cursor.
6. Commit the transaction.
7. Go back to step 2.
When it goes back to step 2 is when the ORA-600 appears. So the first time it works. The second time doing the exact thing - causes the error. We see this happening with both Microfocus COBOL (Visual COBOL) and Microsoft C# both of which are using Oracle.DataAccess DLL. Note the above steps are for COBOL. The C# has a different set of calls but is essentially doing the same thing.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms