- 3,716,000 Users
- 2,242,928 Discussions
- 7,845,734 Comments
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 476 General Database Discussions
- 22 Multilingual Engine
- 487 MySQL Community Space
- 5 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 417 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 9 DevOps
- 3K QA/Testing
- 256 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 67 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
Issues after last CPU 20180417 on Windows with ODP.NET
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 18.104.22.168.180417:(27381640)