My Oracle Support Banner

ODP.NET Unanaged Driver Throws ORA-1036 by Unnecessary Check for Bind Parameters (Doc ID 2656556.1)

Last updated on APRIL 10, 2020

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

When BindByName property of OracleCommand class is set to true, ODP.NET attempts to interpret placeholders in a SQL statement by their parameter names.
In this behavior, ODP.NET Unmanaged driver checks all parameters and would return the error ORA-1036 if a parameter which does not match any placeholder name in the SQL statement has been bound.

According to the following sample code, although the parameter named "param2" is 'unnecessary' bound for the SQL execution, ODP.NET Unmanaged driver redundantly checks it and throws ORA-1036.

 The above code works with using ODP.NET Managed driver.

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
 WORKAROUND
 CAUSION WHEN UPGRADING
References


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