ORA-28527 When Selecting Lob Column Using TG4DRDA or DG4DRDA up to Version 11.2
Last updated on JANUARY 19, 2017
Applies to:Oracle Database Gateway for DRDA - Version 10.2 to 188.8.131.52
Information in this document applies to any platform.
***Checked for relevance on 24-Nov-2010***
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.
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