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 ]