Oracle存储过程怎么传入一个带有 like '% %' 的字符串参数。
包的定义:
create or replace package Test is
TYPE RSCUROSR IS REF CURSOR;
procedure test(v_sql in varchar2,mycs out RSCUROSR )
end Test;
包的body代码如下:
create or replace package body Test is
procedure test(v_sql in varchar2,mycs out RSCUROSR )
IS
strV_SQL varchar2(4000);
BEGIN
strV_SQL :='select * from table where || v_sql||'';
OPEN R_MYCS FOR
strV_SQL;
END;
end Test;
现在我向v_sql传入的是带有like '% %'的字符串来进行模糊查询要怎么做呢?比如v_sql=tableName like '%name%'
请高手指点。