DG4DRDA 11.2.0.3 Query Using Trim Function Results in ORA-28500 Error - Statement Too Long or Too Complex (Doc ID 1433523.1)

Last updated on MARCH 22, 2012

Applies to:

Oracle Database Gateway for DRDA - Version: 11.2.0.3 to 11.2.0.3 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms


After upgrading Database Gateway for DRDA (DG4DRDA) from version 11.2.0.2 to 11.2.0.3 on an AIX 64 bit platform the TRIM function which used to work in 11.2.0.2 now fails with the following error -


[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]STATEMENT TOO LONG OR TOO COMPLEX. 3 {HY000,NativeErr = -101}
Exiting hgopoer, rc=0 at 2012/03/08-08:37:41
hgopars, line 526: calling SQLNumResultCols got sqlstate HY000
Exiting hgopars, rc=28500 at 2012/03/08-08:37:41 with error ptr FILE:hgopars.c LINE:556 ID:Preprocess number of columns
hostmstr: 499794: HOA After hoxpars

Cause

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