public void inputCusChargeList(CorChargeDTO corChargeDTO) throws PafaDAOException {
//  Map map=new HashMap();
//  map.put("partyNo",corChargeDTO.getPartyNo());
//  map.put("parentAccNum",corChargeDTO.getParentAccNum());
//  map.put("addTellerNo",corChargeDTO.getAddTellerNo());
//  map.put("auditTellerNo",corChargeDTO.getAuditTellerNo());
//  map.put("accList",corChargeDTO.getAccList());
//  this.getSqlMapClientTemplate().queryForObject("chargeAccManage_input",map);
//  logger.debug("retcode："+map.get("retcode"));
//  logger.debug("retmessage："+map.get("retmessage"));
  
  Connection con = null;   
     CallableStatement stmt = null;   
   
     String retcode="";
     String retmessage="";
     try {   
      con = ((WLConnection)getSqlMapClientTemplate().getDataSource().getConnection()).getVendorConnection();

      if (con != null) {   
       ARRAY aArray = this.getArray(con,dbTypeUserName+".BCOMS_CORCHARGE_ACC_TYPE",dbTypeUserName+".BCOMS_CORCHARGE_ACC_TBL_TYPE",corChargeDTO.getAccList());
        //該函數調用的第二三個參數必須大寫
        stmt = con.prepareCall("call BCOMS_Corclient_others_pkg.bcoms_inputCorCharge_pro(?,?,?,?,?,?,?)"); //調用某個存儲過程  
        stmt.setString(1,corChargeDTO.getPartyNo());
        stmt.setString(2,corChargeDTO.getParentAccNum());
        stmt.setString(3,corChargeDTO.getAddTellerNo());
        stmt.setString(4,corChargeDTO.getAuditTellerNo());
        ((OracleCallableStatement) stmt).setARRAY(5, aArray);   
        stmt.registerOutParameter(6, java.sql.Types.VARCHAR); 
        stmt.registerOutParameter(7, java.sql.Types.VARCHAR);  
        stmt.execute();   
        retcode = stmt.getString(6);  
        retmessage=stmt.getString(7);  
     logger.debug("retcode："+retcode);
     logger.debug("retmessage："+retmessage);
      }    
     } catch (Exception e) {   
      e.printStackTrace();
      throw new PafaRuntimeException("embis.bcoms.db.error",e);
     } finally {  
      try {
       if(stmt!=null){
        stmt.close();//釋放數據庫連接   
       }
       if(con!=null){
        con.close();
       }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
    logger.error("關閉連接時發生異常", e);
    throw new PafaRuntimeException("embis.bcoms.db.error",e);
   }
     
     
     }   
    
    
  
 }

 private  ARRAY getArray(Connection con, String OracleObj,   
      String Oraclelist, List objlist) throws Exception {   
      ARRAY list = null;   
      if (objlist != null && objlist.size() > 0) {   
       StructDescriptor structdesc = new StructDescriptor(OracleObj, con);   
       STRUCT[] structs = new STRUCT[objlist.size()];   
       Object[] result = new Object[0];   
       for (int i = 0; i < objlist.size(); i++) {   
       CorChargeDTO chargeDTO= (CorChargeDTO) objlist.get(i);
        result = new Object[6];//數組大小應和你定義的數據庫對象(AOBJECT)的屬性的個數   
        result[2] =chargeDTO.getAccNum() ;  //將list中元素的數據傳入result數組   
        result[3] = chargeDTO.getAccName();  //   
           
        structs[i] = new STRUCT(structdesc, con, result);   
       }   
       ArrayDescriptor desc = ArrayDescriptor.createDescriptor(Oraclelist,   
         con);   
       list = new ARRAY(desc, con, structs);   
      } 
      return list;   
 }

 項目中采用的是Weblgoic 的數據源 ,JndiObjectFactoryBean ,批量導入list 類型 ,引入了weblgic lib 中oracle  的jdbc的包,直接操作connection.

getVendorConnection()---------------RemoveInfectedConnectionsEnabled  設置上.