Oracle批量插入数据SQL语句太长出错：无效的主机/绑定变量名

        @Override
    public int insertAllAuditSjxmfw(String sjxmdm, List<ZWXMZD> list) {
        sjxmManagerDao2.deleteAuditSjxmfw(sjxmdm, null);
        int num = 200;
        if (list.size() <= num) {
            sjxmManagerDao2.insertAllAuditSjxmfw(sjxmdm, list);
        } else {
            int times = (int) Math.ceil(list.size() / Double.valueOf(num));
            for (int i = 0; i < times; i++) {
                System.out.println("分批插入："+ i);
                sjxmManagerDao2.insertAllAuditSjxmfw(sjxmdm, list.subList(i * num, Math.min((i + 1) * num, list.size())));
            }
        }
        return 1;
    }

Oracle批量插入数据SQL语句太长出错：无效的主机/绑定变量名

原文：https://www.cnblogs.com/sunBinary/p/11527738.html