I have the following:
Connection conn = null;
OracleCallableStatement orclCallStmt = null;
Integer[] ackinfo = new Integer[ack.size()];
ack.toArray(ackinfo);
Integer[] nakinfo = new Integer[nak.size()];
nak.toArray(nakinfo);
query = "call pm_pbx_systems.updateInfTransport(?,?)";
oracle.sql.ARRAY ackList;
oracle.sql.ARRAY nakList;
ArrayDescriptor acks = ArrayDescriptor.createDescriptor( "T_NUMBER_ARRAY", conn);
ackList = new ARRAY(acks, conn, ackinfo);
ArrayDescriptor naks = ArrayDescriptor.createDescriptor( "T_NUMBER_ARRAY", conn);
nakList = new ARRAY(naks, conn, nakinfo);
orclCallStmt = (OracleCallableStatement) conn.prepareCall(query);
orclCallStmt.setObject(1, ackList);
orclCallStmt.setObject(2, nakList);
orclCallStmt.execute();
CREATE OR REPLACE TYPE t_number_array AS TABLE OF number;
I am using OJDBC7.jar for Oracle 12C.
I would like not to use a deprecated method.