ora-01560 如何解决

[weixin_41044094]

and ci.staff_id in( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and nci.I1 like ?||'%')
--参数:[31562, 31563, 31582, 31583, 31584, 31585, 31586, 31587, 31588, 31683, 31684, 31685, 31695, 31686, 31687, 31688, 31689, 31690, 31691, 31692, 31693, 31694, 31696, 31762, 31697, 31698, 31699, 31700, 31701, 31702, 31703, 31704, 31705, 31706, 31707, 31708, 31709, 31710, 31711, 31712, 31713, 31714, 31715, 泉州电信（销户，欠费停机）一年以上2017年11月（旧）催缴减工单（2）309条20171113]




and ci.staff_id in( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and nci.I1 like ?||'%')
java.sql.SQLException: ORA-01560: LIKE 样式包含的字符不完整或非法

[碧水幽幽泉]

改成like ''||?||'%' 再试试看。

[自由自在_Yu]

?||'%这个不合法，“?”要放在引号里面 ‘?’||'%'