Clob - ARRAY, Fail to convert to internal representation
546734Oct 27 2009 — edited Nov 11 2009I pass arrays all the time for other things. But this is my first go at trying to do so with clobs and wondering if it is possible and what the trick is.
So I have a type in the database. "create type clobtable as table of clob"
I get my Descriptor
ArrayDescriptor clobTable = ArrayDescriptor.createDescriptor("CLOBTABLE",myConn);
so far so good. I get an error though when I try to initialize my ARRAY with a string array
just assume myStringArray = String[] (with data in there of course).
ARRAY myClobArray = new ARRAY(clobTable,myConn,myStringArray);
This gives me the following error.
java.sql.SQLException: Fail to convert to internal representation: ...
This approach works fine for number tables and varchar2 tables that I have. I tried passing a two dimensional byte array
but got the same error for that as well.
Any thoughts on how to do this would be appreciated.
thanks...