posted 15 years ago
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 ?