dynamic pl/sql

hi ng,

is there a way to pass a list of items into a package or procedure?

for example...
i want to return some field where name = 'Mark', 'John', 'Mike' -- this list will NOT contain a set number of items

create procedure test
vList varchar2
as
Select *
From table
Where name is in vList (can i use instr and say -- Where instr(vList, name) > 0)

can pl/sql be built in the procedure and be run? declare vSQL varchar2
vSQL = "Select * from table"
execute vSQL

thanks in advance,
MarkD Received on Fri Oct 06 2006 - 16:12:09 CDT