Problem:

• Product Name: BES
• Product Version: 6.5
• Product Component: Oracle OCI Driver
• Platform/OS Version: All

OCI client not working properly with CLOB -- it doesn't work with Stored Procedures that require CLOB as input parameters.

Following stack trace is thrown:

java.lang.UnsatisfiedLinkError: lob_createTemporary
at oracle.jdbc.oci8.OCIDBAccess.lob_createTemporary(Native Method)
at oracle.jdbc.oci8.OCIDBAccess.createTemporaryLob(OCIDBAccess.java:3622)
at oracle.sql.LobDBAccessImpl.createTemporaryClob(LobDBAccessImpl.java:725)
at oracle.sql.CLOB.createTemporary(CLOB.java:1011)

Oracle OCI Version: 9i, 9.2.0.1.0

Resolution:

Firstly ensure that the OCI client libraries are deployed to the partition, and native libraries are available in the partition's path and is accessible at runtime. 

And then for this particular error, apply OCI 9.2.0.6.0 Client Patch.

Author: Cynthia Huang