java傳集合到oracle的預存程序中

1.oracle先建立一個自訂的table類型(註：類型的名稱必須要大寫，否則會報無效名稱)

CREATE OR REPLACE TYPE MAILIDTABLE AS TABLE OF NUMBER(1);

2.java方面(註：這裡必須要重建立立一個串連，不能使用com.jolbox.bonecp串連池裡面的串連，至於其它串連池，我就沒有試過了)

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","user","pwd");

ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor("MAILIDTABLE",connection);ARRAY array_to_pass = new ARRAY(arrayDesc, connection, mIdList.toArray(new Integer[mIdList.size()]));OracleCallableStatement statement = (OracleCallableStatement) connection.prepareCall("call MAIL_DELETE(?)");statement.setArray(1, array_to_pass);