I think I found a bug in the managed driver from ODAC 12c Release 3 (12.1.0.2.1). It is similar to the one discussed in Problem with ODP.NET Managed driver, update nclob raises ORA-01483, but also happens with shorter CLOBs. So maye an additional fix is required.
I'm trying to insert two strings to CLOB columns in addition to some other columns. Altough I try to insert the same data, a different error is thrown depending on the parameter order.
If I bind the shorter string first, the error is:
ORA-01483: invalid length for DATE or NUMBER bind variable
If I bind the longer string first, the error is:
ORA-01461: can bind a LONG value only for insert into a LONG column
Please see the attached archive for a sample solution that reproduces both errors.
System environment:
- Fully managed driver from ODAC 12c Release 3 (12.1.0.2.1) - the driver that requires the instant client doesn't show this problem.
- .NET Framework 4.5.2
- Windows 7 SP1 x64
- Server: 11.2.0.4.0 running on Windows Server 2008 R2 x64
Sadly, this errors happen quite often in my application and prevent me from switching to the managed driver, so a bugfix release or workaround would be greatly appreciated.