declare
v_sql varchar2(2000);
v_out sys_refcursor;
begin
v_sql := 'select * from test where id like :1';
open v_out for v_sql
using '%001%';
end;
declare
v_sql varchar2(2000);
v_out sys_refcursor;
begin
v_sql := 'select * from test where id like :1';
open v_out for v_sql
using '%001%';
end;