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;
}