Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Clob - ARRAY, Fail to convert to internal representation

546734Oct 27 2009 — edited Nov 11 2009
I 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2009
Added on Oct 27 2009
4 comments
5,090 views