Re: select ... where col in (collection)

roger wrote:

>Daniel Morgan <damorgan_at_exxesolutions.com> wrote in news:1062981092.542083
>@yasure:
>
>
>
>>Go to http://tahiti.oracle.com and look up:
>>
>>CAST and MULTISET
>>
>>You should find plenty of examples.
>>
>>
>>
>
>All of the examples I find are using cast in the select list,
>which I can understand just fine.
>
>What I still don't see is how to use cast in order to allow
>me to use the collection variable with the IN operator in
>the where clause:
>
> where col IN (collection_variable)
>
>I'm guessing it would be
>
> where col IN ( cast(collection_variable as something) )
>
>but what to use for the "something" part???
>
>
>

Before we go any further ... what is it you are trying to do? Pass a group of records into our out of a procedure?

If so ... just use a REF CURSOR. There is no need to over-complicate a simple task.

If not ... what is it you are trying to do that a REF CURSOR can't accomplish?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)