Select From DB2 10.2 Column-organized Table Using DG4DRDA 12.1 Gives ORA-28501 (Doc ID 2014047.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

 A select from a column-organised table in DB2 10.5 using the Database Gateway for DRDA (DG4DRDA) 12.1 gives the error -

SQL> select * from db2inst.testcol@db2;
select * from db2inst.testcol@db2
                     *
ERROR at line 1:
ORA-28501: communication error on heterogeneous database link
ORA-02063: preceding line from DB2


The table was created in DB2 as -

  

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