oracle.sql.ARRAY oracleArray = new ARRAY(arraydesc, connection, elements);
But I retrieve the connection from weblogic server DataSource configed using the exactly same parameter, but cannot create oracle ArrayDescriptor and oracle.sql.ARRAY instances, I got following errors:
Fail to construct descriptor: Unable to resolve type: "UUM.FIELDIDARRAY" where UUM is database schema name. I checked the database, we have FIELDIDARRAY object defined in Oracle under this schema.
Would someone help me out about this issue? [ October 22, 2004: Message edited by: hongwei wang ]
You're trying to use an Oracle proprietary extension. There is no way that WLS or anything else can support that in a way that would work with every driver. You'll have to do it like you are doing it to use Oracle arrays.
<a href="http://forums.hotjoe.com/forums/list.page" target="_blank" rel="nofollow">Java forums using Java software</a> - Come and help get them started.