how to create a stored procedure having a list of values as input
parameter?
I need to retrieve result for query looking like

select field1, field2 from table1 where field3 in (1, 2, 3, 4);

is there a way to give list of values as input parameter? but sometimes
there could be just one value for input. so it should work also for
select field1, field2 from table1 where field3 in (1);