I have a StoredProceude that has a Clob as one of the input parameters.
(We're saving an XML file to the database).
I have ojdbc14.jar in the classpath.
when I call:
oracle.sql.CLOB tempClob = oracle.sql.CLOB.createTemporary(conn, true, oracle.sql.CLOB.DURATION_SESSION);
using a DataSource and Connection pool in WebLogic I get null pointer exceptions. If I hard code the connection with the exact same driver, url and credentials it works perfectly - even using the oracle thin connection
string.
Has anyone been able to load a clob using a DataSource?
[ January 14, 2005: Message edited by: Alex Beekman ]