Java中数组的返回值怎么写,在Java中获取PL / SQL数组返回值

在Java中，如何从pl/sql返回数组的函数中获取值。

如果我的pl /

sql函数返回名为的数组myArray，那么在Java中是否可以使用从中获取值myArray到Java对象中callablestatement？

谢谢

更新1

我正在调用函数的Java代码，但是却遇到异常。

PLS-00306: wrong number or types of arguments in call to 'myfunc'

connection = con.getConnection();

callablestatement = connection.prepareCall("{call myfunc(?,?,?}");

callablestatement.setInt(1, param1);

callablestatement.setInt(2, param2);

callablestatement.setString(3, param3);

callablestatement.registerOutParameter(4, Types.ARRAY);

callablestatement.execute();

resultSet = callablestatement.getArray(4).getResultSet();

更新2

private final String PRODECURE_NAME = "{? = call myfunc(?,?,?)}";

和

connection = con.getConnection();

callablestatement = connection.prepareCall(PRODECURE_NAME);

callablestatement.registerOutParameter(1, Types.ARRAY);

callablestatement.setInt(2, param1);

callablestatement.setInt(3, param2);

callablestatement.setString(4, param3);

callablestatement.execute();

create or replace type dates

is varray(100) of varchar2(32);

功能

CREATE OR REPLACE function myfunc (

p_id IN number,

p_c_id IN number,

p_co_no IN number

)

RETURN dates

AS

myarray contract_dates;

par1 VARCHAR2 (32);

par2 VARCHAR2 (32);

固定更新3

connection = con.getConnection();

callablestatement =

connection.prepareCall("begin ? :=myfunc(?,?,?); end;");

callablestatement.registerOutParameter(1, OracleTypes.ARRAY, "DATES");

callablestatement.setInt(2, param1);

callablestatement.setInt(3, param2);

callablestatement.setString(4, param3);

callablestatement.execute();