My Oracle Support Banner

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 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

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