create or replace procedure test(v_condition string)
as
...
begin
v_sql:='select * from table where ... and id in ('||v_condition||')';
.....
as
...
begin
v_sql:='select * from table where ... and id in ('||v_condition||')';
.....
as
...
begin
v_sql:='select * from table where ... and id in ('||v_condition||')';
execute immediate v_sq;
...