My Oracle Support Banner

Ora-28528 Data Truncated With DG4ODBC And Informix ODBC Driver (Doc ID 1400946.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms


Using DG4ODBC 11.2 with IBM ODBC driver for Informix on Windows, the following errors occurs:

SQL> select * from va4expans@va_egg_echt;
ERROR:
ORA-28528: Heterogeneous Services datatype conversion error
[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}
ORA-02063: preceding line from DG4ODBC




===>Gateway trace file shows

SQL text from hgodtab, id=0, len=25 ...
   00: 73656C65 6374202A 2066726F 6D202056  [select * from  V]
   10: 41344558 50414E53 20                 [A4EXPANS ]
...
Entered hgopoer at 2012/01/23-10:42:43
hgopoer, line 231: got native error -11003 and sqlstate 01004; message follows...
[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}
Exiting hgopoer, rc=0 at 2012/01/23-10:42:43
hgoftch, line 740: calling SQLFetch got sqlstate 01004



===>ODBC driver  trace file shows:

dg4odbcVA_EGG_E 1a98-23f8 ENTER SQLFetch
HSTMT               0x00000000043ECC60

dg4odbcVA_EGG_E 1a98-23f8 EXIT  SQLFetch  with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT               0x00000000043ECC60

DIAG [01004] [Informix][Informix ODBC Driver]Data truncated. (-11003)

DIAG [01004] [Informix][Informix ODBC Driver]Data truncated. (-11003)

DIAG [01004] [Informix][Informix ODBC Driver]Data truncated. (-11003)



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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.