ORA-00600: internal error code, arguments: [HO define: Long fetch], [], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [HO define: Long fetch], [], [], [], [], [], [], [], [], [], [], []

Hi,

While fetching the data over dblink between Oracle & MS SQL database, got below error:

SQL> select * from "dbo"."ACC_TAB"@mssql;

select * from "dbo"."ACC_TAB"@mssql

ORA-00600: internal error code, arguments: [HO define: Long fetch], [], [], [], [], [], [], [], [], [], [], []

SQL>

Solution:

You can follow below MOS Doc to resolve this.

ORA-600 [HO define: Long fetch] Error Message When Selecting Data Via Oracle Database Gateways (Doc ID 1224783.1)

In my case, found that base table in MS SQL database "ACC_TAB" having columns datatype "varchar(max)", hence got the error.

In order to resolve this, I have modified the column and defined the column length and created index on the same column to fetch the data faster. Bingo! issue has been resolved. I can able to fetch data over dblink.

alter table [dbo].[ACC_TAB] ALTER COLUMN [Account] varchar(30);

create index acc on  [dbname].[d]bo.[ACC_TAB] ([Account]);

SQL> select * from "dbo"."ACC_TAB"@mssql;

--------

901212

Cheers !