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.
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?