Ok.. Made some progress....
Now its going past the following code
ArrayDescriptor descriptor =
ArrayDescriptor.createDescriptor("NUM_ARRAY", conn);
ARRAY array = new ARRAY (descriptor, conn,
orderIdArr);
arg0.setArray(array);
After that it throws a NullPointerException. I don't see the property
runDetailRS being set. I feel the way I have set the array is not
correct. I have a TypeHandler that reads the REF CURSOR and populates
the ResulSet. I know this piece of code works.
Here's the parameter map.
<parameterMap id="test-detail-proc-param"
class="OrderTestFilter" >
<parameter property="orderId" mode="IN" jdbcType="ARRAY"
javaType="java.util.ArrayList"/>
<parameter property="runDetailRS"
jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT"/>
</parameterMap>
-----Original Message-----
From: Koka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 11:00 AM
To: [email protected]
Subject: Re: ArrayDescriptor issue
The error you get usually indicates permission problems.
So it seems that either you have not created ORD_ARRAY type on the
database side or the user you use to open connection does not see it.
It would be easier if you'd post JDBC code AND oracle TYPE/procedure
Good luck
Koka
