oracle存储过程传入in参数，返回结果集

create or replace procedure proc_report_TEST(zhxshss in varchar2, pcursor out sys_refcursor)
as

begin
    open pcursor for
      select * from sys_user t where t.ID in
      ---------------------------zhxshss--传入字符串，逗号分隔--begin--------------
      (SELECT REGEXP_SUBSTR(zhxshss, '[^,]+', 1, LEVEL) AS value_str FROM DUAL 
      CONNECT BY LEVEL <=LENGTH(TRIM(TRANSLATE(zhxshss,TRANSLATE(zhxshss, ',', ' '), ' '))) + 1);
      --该存储过程执行查询操作，返回游标
      --translate(string,from_str,to_str)为替换函数
      --TRIM(TRANSLATE(zhxshss,TRANSLATE(zhxshss, ',', ' '), ' '))去除字符串首尾的空格或任意指定的字符
      ---------------------------zhxshss--传入字符串，逗号分隔--end----------------
end;