Updating, Inserting a DB2 Table With More Then 83 Bind Variables Fails (Doc ID 1369278.1)

Last updated on OCTOBER 20, 2011

Applies to:

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

Symptoms


Using an update statement with more then 83 bind variables fails with error:
[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]LENGTH OF INPUT HOST VARIABLE NUM 85 NEGATIVE OR GREATER THAN MAX. {HY000,NativeErr = -311}
ORA-02063: preceding 2 lines from DG4DB2

Or insert statements with more 83 bin variables can fail with:
[Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]VALUE OF
INPUT HOST VARIABLE NUM 85 NOT USED; WRONG DATA TYPE. {HY000,NativeErr =-301}

Changes

Update from 11.2.0.1 or 11.2.0.2 Database Gateway for DRDA to 11.2.0.3

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