My Oracle Support Banner

ORA-28527 When Selecting Lob Column Using TG4DRDA or DG4DRDA up to Version 11.2 (Doc ID 462655.1)

Last updated on MAY 11, 2022

Applies to:

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


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.


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

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