My Oracle Support Banner

'java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL' in JDBC 11.2.0.1.0 (Doc ID 1074130.1)

Last updated on AUGUST 30, 2023

Applies to:

JDBC - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When trying to use named parameter with OracleCallableStatement with JDBC 11.2.0.1 against an Oracle database 11.2.0.1, then following exception is obtained:

java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: <NAME>

When the same code is executed with 11.1.0.7.0  JDBC driver against the same 11.2.0.1 database, it works fine.

Changes

 

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


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