My Oracle Support Banner

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

Last updated on JULY 26, 2021

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

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
Symptoms
Cause
Solution
References


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