Getting Ora-600 From User Session When Selecting a SQL-Server View With Only One LONG column
(Doc ID 2271897.1)
Last updated on MARCH 26, 2019
Applies to:Oracle Database Gateway for SQL Server - Version 18.104.22.168 and later
Information in this document applies to any platform.
ORA-00600: internal error code, arguments: [HO define: Long fetch], , , , , , , , , , , 
Developer is using <Company Name> 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 <Company Name> COBOL (Visual COBOL) and <Company Name> 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.
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