批量执行存储过程：不允许的操作: Stored procedure with out or inout parameters cannot be batched

Question

 

 

if(parameters == null || parameters.size() <= 0) { return result; }
            conn.setAutoCommit(false);
            String sql = "call" + procedure + "(";
            for (int i = 0; i < parameters.get(0).length; i++)
            {
                sql += "?,";
            }
            sql += "?)";
            CallableStatement cs = conn.prepareCall(sql);
           
            for (int i = 0; i < parameters.size(); i++)
            {
                this.prepareCommand(cs, parameters.get(i));
                cs.registerOutParameter(parameters.get(i).length-1, oracle.jdbc.OracleTypes.NUMBER);
                cs.addBatch();
            }
            cs.executeBatch();
            conn.commit();

 

不允许的操作: Stored procedure with out or inout parameters cannot be batched

Answer 1

当初想执行的存储过程有输出参数，这句去掉就没办法获取输出参数了

Answer 2

去掉这句：
 cs.registerOutParameter(parameters.get(i).length-1,  oracle.jdbc.OracleTypes.NUMBER);