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 11.2.0.2Information in this document applies to any platform.
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
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 |