We're trying to insert a clob into a database table using the JDBC OCI driver and prepared statements. The client and server versions of the database we are using are 188.8.131.52.0 - the linux version.
The code is resident on weblogic application server version 8.1.2, and it works fine using the thin driver regardless of the version of the database. As soon as we tried to use the oci driver the code began to fail where it tries to build the temporary clob.
The code fails with :-
This is the code we use to populate the prepared statement with the clob :-
Any ideas on what the problem might be? Is there a known bug with the oci driver for version 184.108.40.206.0? We tried to use but that didn't work either.
posted 12 years ago
Found the problem.
The ojdbc14.jar that ships with weblogic 8.1.2 is incorrect. That jar contains invalid values for the constants CLOB.DURATION_SESSION and CLOB.DURATION_CALL.