Home > ORA-XXX > ORA-28528: Heterogeneous Services datatype conversion error

ORA-28528: Heterogeneous Services datatype conversion error

September 28, 2012 Leave a comment Go to comments

My database version 11gR2.0.2, there is a db link connecting to a postgre db. Once issue select * from testing_table. The errors returns

ORA-28528: Heterogeneous Services datatype conversion error
ORA-02063: preceding line from NICEIEXLK

Solution.

Add the optional below into HS agent configuration ($ORACLE_HOME/hs/admin). The problem is fixed. The details refer to the Oracle Support (Datatype Conversion Error ORA-28528 Using Dg4odbc With Informix, MySQL or SQL*Server 64-bit ODBC Drivers on Unix Platforms [ID 55440])

HS_FDS_SQLLEN_INTERPRETATION=32

Advertisements
Categories: ORA-XXX
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: