create or replace type t_id as object ( id number( 38 ) )
/
create or replace type tbl_id as table of t_id
/

 public   class  PreparedStructTest {

   private   static   final  String T_ID = "T_ID";
   private   static   final  String TBL_ID = "TBL_ID";

   private   static   final  String USERNAME = "scott";
   private   static   final  String PASSWORD = "tiger";
   private   static   final  String URL = "jdbc:oracle:thin:@<host>:<port>:<SERVICE_NAME>";

   public   static   void  main(String[] args)
     throws  SQLException {
    DriverManager.registerDriver( new  oracle.jdbc.OracleDriver());
    // Коннект к Oracle.
    Connection con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
    OraclePreparedStatement st = (OraclePreparedStatement) con.prepareStatement(
      "select e.*\n" +
      "from scott.emp e\n" +
      "where e.empno in (\n" +
      "  select id from table(cast(? as tbl_id))\n" +
      ")"
    );

     int [] emps = { 7369 ,  7499 };
    ARRAY array = getIntArray(con, emps);
    st.setARRAY( 1 , array);
    ResultSet rs = st.executeQuery();
     while  (rs.next()) {
      System.out.println(rs.getString("empno") + " " + rs.getString("ename"));
    }
    rs.close();
    st.close();
    con.close();
  }

   public   static  ARRAY getIntArray(Connection con,  int [] values)
     throws  SQLException {
    // Declare two descriptors, one for the ARRAY TYPE and one for the OBJECT TYPE.
    StructDescriptor structDesc = StructDescriptor.createDescriptor(T_ID, con);
    ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor(TBL_ID, con);

    // Initialize the Input array object - to an array of STRUCT Objects.
    ArrayList pArrayList =  new  ArrayList();
     if  (values !=  null ) {
      // Declare the Object arrays that will store the data.
      Object[] pRecord =  new  Object[ 1 ];
      // Create the STRUCT objects to associate the host objects with the database records.
       for  ( int  i =  0 ; i < values.length; i++) {
        pRecord[ 0 ] =  new  Integer(values[i]);
        pArrayList.add( new  STRUCT(structDesc, con, pRecord));
      }
    }
    // Set up the ARRAY object.
    ARRAY pARRAY =  new  ARRAY(arrayDesc, con, pArrayList.toArray());
     return  pARRAY;
  }

}