数据做为存储过程参数在JAVA中的调用

--定义数组，该数据不能定义在包中
CREATE OR REPLACE TYPE idArray AS TABLE OF integer;
--包头
CREATE OR REPLACE PACKAGE pg_data_acquire IS
PROCEDURE p_test( ids IN idArray, exist OUT NUMBER);
END pg_data_acquire;

--包体
CREATE OR REPLACE PACKAGE BODY pg_data_acquire IS
PROCEDURE p_test(
 ids IN idArray, 
 exist OUT NUMBER) AS
 v_Index BINARY_INTEGER;
BEGIN
 v_Index:= ids.FIRST;
 LOOP
    dbms_output.put_line(ids(v_Index));
  EXIT WHEN v_Index=ids.LAST;
  v_Index:= ids.NEXT(v_Index);
 END LOOP;
 exist :=v_Index;
END p_test;
END pg_data_acquire;

--JAVA程序调用
 public class TestArrays
{
 public static void main(String[] args)
 {
 
  try {
     Class.forName("oracle.jdbc.driver.OracleDriver");
 
     Connection con = DriverManager.getConnection("jdbc:oracle:thin:@sr0002sz:1521:orcl",&#