Re: dynamic pl/sql

From: MD <md_at_md.com>
Date: Wed, 11 Oct 2006 16:43:06 -0500
Message-ID: <MzdXg.27643$b23.1017@dukeread07>

This is exactly what I needed.

Thanks,
MarkD

"joel garry" <joel-garry_at_home.com> wrote in message news:1160173148.979001.238400_at_k70g2000cwa.googlegroups.com...
>
> 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
>
Received on Wed Oct 11 2006 - 16:43:06 CDT