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 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


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.