(my previous post appeared under another thread, as I did reply. I write
again to start new thread - sorry if someone gets 2 times).

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);

thank you.