I am trying to use the execute service adapter template which executes a java service using the connection parameter from pipeline to execute a function on a Oracle8i database.
java.sql.Connection conn =
I am able to execute simple procedures and functions which involes only varchar and number types but the problem is i have to insert a clob data to my procedure call which fails with below error.
[ADA.1.345] Exception occured when executing Service “testService”
I could figure out its failing for temporary clob creation.
tempClob = CLOB.createTemporary( conn, false, CLOB.DURATION_SESSION );
deep copy problems: com.wm.app.b2b.server.ServiceException: Exception :$Proxy6
Before Clob Creation - Connection - oracle.jdbc.driver.T4CConnection@2ad006
Any one has seen this error before?