ORA-28527 When Selecting Lob Column Using TG4DRDA or DG4DRDA up to Version 11.2

(Doc ID 462655.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for DRDA - Version 10.2 to 11.2.0.2
Information in this document applies to any platform.
***Checked for relevance on 24-Nov-2010***


Symptoms

Selecting from a DB2 table with a column defined as a LOB - for example CLOB or BLOB - will give the following error -

 

SQL> select * from tg1020.momblob@drda_link ;
select * from tg1020.momblob@drda_link
*
ERROR at line 1:
ORA-28527: Heterogeneous Services datatype mapping error
ORA-2063: preceding line from DRDA_LINK

DG4DRDA 12.1 and later versions now support DB2 BLOB. A BLOB column will be converted to Oracle LONG RAW and CLOB and DBLOB columns to a LONG.

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