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