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 JANUARY 09, 2017

Applies to:

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


 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 -



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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.