Re: dynamic pl/sql

MD wrote:
> 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)
>
>
> --------------------------------------------------------------------
> OR
>
> can pl/sql be built in the procedure and be run?
> declare vSQL varchar2
> vSQL = "Select * from table"
> execute vSQL
>
>
> thanks in advance,
> MarkD

Maybe
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:210612357425 ?

jg

--
@home.com is bogus.
http://biz.yahoo.com/ap/061006/google_youtube.html?.v=5