oracle store procedure taking a list of values at run time ?

[ben oliver]

Want to use oracle store procedure, one of the input is a list. The list can have different number of elements at run time. is it possible to pass such a list to a store procedure ? for example, if I want to the following --

select * from ... where ... AND
id IN ('11', '12','13','14');

this is static, I want to pass a list of "id" to the store procedure at run time, don't know how I can write store procedure for this case ?

[Paul Campbell]

your stored procedure would need to except a string/varchar as a variable. Your list would be passed as a single string variable. You will need to parse the string to utilize your list.

Here is an example from Tom Kyte's Oracle Page