create TYPE T_Date as table of date;
         create TYPE T_Number as table of number;
         create TYPE T_VCH2_100 as table of VARCHAR2(100);

CREATE OR REPLACE procedure load_file_full (
        --
        a_MSISDN              in  T_VCH2_100,
        a_MNC                   in T_VCH2_100,
        a_OperatorID          in  T_VCH2_100,
        a_RegionID             in T_VCH2_100,
        a_RN                    in  T_VCH2_100,
        a_PortDate            in  T_Date
    ) 
...

  CREATE OR REPLACE TYPE T_MNPTRANSFER_FULL as object (
     MSISDN      VARCHAR2(22),
     MNC         VARCHAR2(10),
     OPERATORID  VARCHAR2(200),
     RN          VARCHAR2(10),
     REGIONID    VARCHAR2(10),
     PORTDATE    DATE
);
CREATE OR REPLACE TYPE TT_MNPTRANSFER_FULL as table of T_MNPTRANSFER_FULL;

CREATE OR REPLACE procedure load_file_full_o (
        --
        tbl_full                  in TT_MNPTRANSFER_FULL
    )
    ....

            String[]            a_MSISDN        = new String[size];
            String[]            a_MNC           = new String[size];
            String[]            a_OperatorID    = new String[size];
            String[]            a_RegionID      = new String[size];
            String[]            a_RN            = new String[size];
            Timestamp[]         a_PortDate     = new Timestamp[size];

            int i = -1;
            for (Item object : items) {
                i++;
                a_MSISDN[i]     = object.MSISDN;
                a_MNC[i]        = object.MNC;
                a_OperatorID[i] = object.OperatorID;
                a_RegionID[i]   = object.RegionID;
                a_RN[i]         = object.RN;
                a_PortDate[i]   = new Timestamp(object.PortDate.getTime());
            }

            ARRAY aa_MSISDN         = ((oracle.jdbc.OracleConnection)cn).createARRAY("T_VCH2_100",a_MSISDN);
            ARRAY aa_MNC            = ((oracle.jdbc.OracleConnection)cn).createARRAY("T_VCH2_100",a_MNC);
            ARRAY aa_OperatorID     = ((oracle.jdbc.OracleConnection)cn).createARRAY("T_VCH2_100",a_OperatorID);
            ARRAY aa_RegionID       = ((oracle.jdbc.OracleConnection)cn).createARRAY("T_VCH2_100",a_RegionID);
            ARRAY aa_RN             = ((oracle.jdbc.OracleConnection)cn).createARRAY("T_VCH2_100",a_RN);
            ARRAY aa_PortDate      = ((oracle.jdbc.OracleConnection)cn).createARRAY("T_DATE",a_PortDate);

            String sql_write_tmp = "begin load_file_full(?,?,?,?,?,?); end;";
            cs = cn.prepareCall(sql_write_tmp);

            ((OracleCallableStatement)cs).setARRAY(1,aa_MSISDN);
            ((OracleCallableStatement)cs).setARRAY(2,aa_MNC);
            ((OracleCallableStatement)cs).setARRAY(3,aa_OperatorID);
            ((OracleCallableStatement)cs).setARRAY(4,aa_RegionID);
            ((OracleCallableStatement)cs).setARRAY(5,aa_RN);
            ((OracleCallableStatement)cs).setARRAY(6,aa_PortDate);

            cs.execute();

        StructDescriptor structDesc = null;
        ArrayDescriptor arrayDesc = null;
        structDesc = StructDescriptor.createDescriptor("T_MNPTRANSFER_FULL", cn);
        arrayDesc = ArrayDescriptor.createDescriptor("TT_MNPTRANSFER_FULL", cn);

        ArrayList pArrayList = new ArrayList();

        Object[] pRecord = new Object[6];
        for (Item object : items) {
            pRecord[0]      = object.MSISDN;
            pRecord[1]      = object.MNC;
            pRecord[2]      = object.OperatorID;
            pRecord[3]      = object.RN;
            pRecord[4]      = object.RegionID;
            pRecord[5]      = new Timestamp(object.PortDate.getTime());
            pArrayList.add(new STRUCT(structDesc, cn, pRecord));
        }
        ARRAY pARRAY = new ARRAY(arrayDesc, cn, pArrayList.toArray());
        String sql_write_tmp = "begin load_file_full_o(?); end;";
        CallableStatement cs = null;

        try{
            cs = cn.prepareCall(sql_write_tmp);
            ((OracleCallableStatement)cs).setARRAY(1,pARRAY);
            cs.execute();
        }finally {
            DBHelper.release(cs);
        }

CREATE OR REPLACE procedure load_file_full (
        --
        a_MSISDN              in  T_VCH2_100,
        a_MNC                 in  T_VCH2_100,
        a_OperatorID          in  T_VCH2_100,
        a_RegionID            in  T_VCH2_100,
        a_RN                  in  T_VCH2_100,
        a_PortDate            in  T_Date
    )
    is
    begin
       if (a_MSISDN.count > 0) then  
          
           if a_MSISDN(1) is null then
              raise_application_error(-20001,'NULL !!!');
           end if;

               forall    i   in    a_MSISDN.first .. a_MSISDN.last
                  insert /* APPEND */ 
                  into TMP_MNPTRANSFER_FULL
                  (MSISDN, MNC, OPERATORID, REGIONID, RN, PortDate)
                  values
                  (
                        a_MSISDN(i),
                        a_MNC(i),
                        a_OperatorID(i),
                        a_RegionID(i),
                        a_RN(i),
                        a_PortDate(i)
                  )
                  ;
       end if;
    end;