Re: OracleParameter and IN Clause

Rick wrote:
> I have a parameterized Select query in which I want to use the parameter in
> the IN clause:
>
> SELECT * FROM TABLENAME
> WHERE MYID IN (:p_Parameter)
>
> MYID is of type VarChar2.
>
> Is this possible? If so, what is the correct way to setup the
> OracleParameter object?
>
> I've tried many variations, but can't get it to work.
>
> Thanks!

Your Oracle version is?

This is the wrong way to approach this. Go to Morgan's Library at www.psoug.org. Click on Conditions. Scroll down to "Complex IN demo."

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)