Getting Ora-600 From User Session When Selecting a SQL-Server View With Only One LONG column (Doc ID 2271897.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms