I have a stored procedure that uses a user-defined data type that is
an array of VARCHAR as its input parameter. Calling the SP from the
CLP works fine:

CALL MYPROC(ARRAY['abc,'def'])

My question is how can this proc be called from within Java code? What
Java data type is required and which methods can be used to populate
the array object and bind it to the callable statement? We can't find
much documentation on the matter.

We're using DB2 v. 9.1 on AIX 5.3, and Java 1.4 type 4 driver.

Thanks for your help,

Evan

On 6/10/2010 10:37 AM, esmith2112 wrote:

Look here:
http://www.ibm.com/developerworks/da...m-0710arocena/

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab