My Oracle Support Banner

Re-using Oracle Style Bind Variables Causes ORA-17041 with JDBC 10g and 11g Drivers (Doc ID 731833.1)

Last updated on NOVEMBER 09, 2023

Applies to:

JDBC - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When using JDBC 10g or 11g drivers,  Oracle style binding that uses the same bind variable twice does not automatically load the same value for the second bind resulting in an ORA-17041: Missing IN or OUT parameter at index error.
This is not an issue in JDBC 9i drivers.

Testcase:

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.