I’ve set up an OCI connection so that I can insert/select large CLOB and BLOB fields, but am encountering issues with selecting these CLOB and BLOB fields.

When I try to return the CLOB field as a java.lang.String Output type I get the following error:
[ART.114.505] Error while invoking adapter service com.wm.adapter.wmjdbc.services.Select.
clob_read

If I try to return the CLOG field as a java.sql.Clob Output type I get the following error:
java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: oracle.jdbc.driver.OracleConnection

If anyone has encountered these error before can you let me know how you got passed it?

Or if you have succesfully set up an OCI connection can you let me know what parameters you had to set up in Windows (ex: PATH) and in the webMethods startup script?

Thanks,
Jason

I solved my own problem… it turned out that I there were two ojdbc14.jar files being loaded. I removed the older one and the problem went away.