OracleParameter and IN Clause

From: Rick <ngrimartin_at_yahoo.com>
Date: Thu, 23 Mar 2006 08:37:41 -0700
Message-ID: <e_OdnTiN8czHXL_ZnZ2dnUVZ_v2dnZ2d_at_comcast.com>

[Quoted] [Quoted] 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! Received on Thu Mar 23 2006 - 16:37:41 CET