My Oracle Support Banner

Oracle Provider For DRDA Error: Parameterized Updates Not Functioning Properly (Doc ID 1925026.1)

Last updated on JANUARY 06, 2015

Applies to:

Oracle Database Provider for DRDA - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The problem occurs with DP4DRDA v12.1.0.2.
An application that simply executes a query to return a small ResultSet and then iterates through that ResultSet and executes a parameterized update for each row. The first update works fine, but when the second update is attempted, the following error occurs:

Error msg: [jcc][10145][10844][3.64.133] Invalid parameter 1: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815
SQLSTATE: 42815
Error code: -4461
Stack trace: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10145][10844][3.64.133] Invalid parameter 1: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:103)
at com.ibm.db2.jcc.am.jo.k(jo.java:5817)
at com.ibm.db2.jcc.am.jo.i(jo.java:5772)
at com.ibm.db2.jcc.am.jo.a(jo.java:1477)
at com.ibm.db2.jcc.am.jo.setString(jo.java:1466)
at com.ingramcontent.jdbctest.SimpleSQLTest.PerformUpdates(SimpleSQLTest.java:65)
at com.ingramcontent.jdbctest.SimpleSQLTest.main(SimpleSQLTest.java:34)

 

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
References


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