存储过程中使用like
如:WHERE OUTID like '%'+ PRMOUTID+'%' AND NAME LIKE '%'+PRMNAME+'%';
出错:06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "CCENSE.PKG_BASE_CUSTOMERS", line 625 ORA-06512: at line 1
...全文
781打赏收藏
包中的存储过程中如何使用like?
存储过程中使用like 如:WHERE OUTID like '%'+ PRMOUTID+'%' AND NAME LIKE '%'+PRMNAME+'%'; 出错:06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "CCENSE.PKG_BASE_CUSTOMERS", line 625 ORA-06512: at line 1