My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

Applies to:

Oracle Database Gateway for DRDA - Version 11.2.0.3 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

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.