I administrate a software which uses normaly the ODP.NET provider: "Oracle.DataAccess.Client".
After updating the database (which is also the client because database and application is on the same server) I got the following error:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
at OracleInternal.ConnectionPool.ConnectionString.Compare(String constr)
at OracleInternal.ConnectionPool.ConnectionString.GetCS(String constr)
at Oracle.DataAccess.Client.OracleConnection.set_ConnectionString(String value)
...
The connection string is (and was not changed): "Password=<xxxx>; User Id=AUD1; Data Source=IADDB" (with corresponding entry in the tnsnames.ora file).
I use now the Microsoft Provider: "System.Data.OracleClient". But with this driver the software is not able to handle CLOB values.
There are many exceptions with this message: "System.Data.OracleClient.OracleException: ORA-01461: can bind a LONG value only for insert into a LONG column" and long texts cannot be inserted or updated in the database.
(And handling of CLOB values was possible with the oracle driver before!)
I would like to switch back to the Oracle driver to prevent these errors.
Oracle.DataAccess.dlls are registered via OraProvCfg.exe for "4" and "2.x".
Managed driver is not installed.
My system: Oracle Database is on same server as application.
Operation system: Windows Server 2008 R2 SP1
Installed Patch: WINDOWS DB BUNDLE PATCH 11.2.0.4.180417:(27381640)