My Oracle Support Banner

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

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

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.