Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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=5Received on Fri Oct 06 2006 - 17:19:09 CDT