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 樣式包含的字符不完整或非法
uj5u.com熱心網友回復：
改成like ''||?||'%' 再試試看。uj5u.com熱心網友回復：
?||'%這個不合法，“?”要放在引號里面 ‘?’||'%'轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/79189.html
標籤：開發
上一篇：ORA-01722：無效數字。
下一篇：求助，oracle的一個奇怪問題