Oracle Error Message
ORA-28528: Heterogeneous Services datatype conversion error
Reason for the Error
Either an Oracle datatype could not be converted to a non-Oracle datatype, or a non-Oracle datatype could not be converted to an Oracle datatype. The following are possible reasons for for the conversion failure: — overflow problems (in the case of numbers) — length limitations (in the case of character strings) — invalid values passed into the conversion routines
Solution
Contact customer support of the agent vendor. If the problem is due to size discrepancies between Oracle and the non-Oracle system, it may not be possible to convert the value.
