ODP.NET Unanaged Driver Throws ORA-1036 by Unnecessary Check for Bind Parameters
(Doc ID 2656556.1)
Last updated on JULY 20, 2024
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 |