Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: collection types / expression list
brenda.beltran_at_gmail.com wrote:
> Hi guys!
>
> I'll appreciate your help in the following case.
>
> I get a varchar parameter, in my procedure, that stores several
> supplier's id (concatenated and separated by commas) which I want to
> use in my where clause as follows: WHERE supp_id
> IN('0852','0236','4520').
>
> The idea is not to have to get a collection type as a parameter,
> preferably we want to be able to convert/cast the varchar in a
> collection list and then use this collection in my where clause.
>
> Thinking about declaring a table type and then populate it, is this
> possible? If so, how do you populate a type table?
>
> Thanks a lot!
www.psoug.org
Click on Morgan's Library
Click on CONDITIONS
Scroll down to "COMPLEX IN DEMO"
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Sep 13 2007 - 16:31:20 CDT