- 3,716,000 Users
- 2,242,928 Discussions
- 7,845,734 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 476 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 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
- 22 JavaScript - Nashorn
- 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 11.2.0.4.180417:(27381640)
Answers
-
Normally, I would recommend backing out the patch on the server or client or both, whichever causes the error. Since this is a CPU, the preferred solution is to diagnose the root cause and fix it. The problem itself may not be due to ODP.NET. It could some issue with the Oracle Client or DB server that the patch changed. I would recommend opening up an Oracle SR and working with Support to diagnose the issue, Oracle then should be able to provide you a workaround or fix to resolve it.
-
Thank you for your answers.
I have created now a service request.
Number is SR 3-17672759281
(I am not able to paste copied things into this application!)