PL/SQL: How pass vals list for "select where in ()"

Hi,
I think what I'm trying to do is simple. All I want to do is to be able to pass a list of values as a parameter into my stored procedure so that I can do something like:

select * from emp where name in (paramVar) - in place of -
select * from emp where name in ('a','b','c')

Needless to say, the whole point of this is that list size will be dynamic and unknown before the proc is called. Passing a simple varchar2 of comma delimited values of course does not work.

Any idea?
Thanks! Received on Mon Jan 22 2001 - 01:52:13 CST