Re: OracleParameter and IN Clause
Date: Thu, 23 Mar 2006 10:15:48 -0700
Message-ID: <KfSdnb6qPJLERb_ZRVn-rw_at_comcast.com>
[Quoted] [Quoted] 10gR1 using ODP.NET from a C# program.
Can you explain why you think this is the wrong way to approach this problem? I've looked at the suggested website which uses a PL/SQL approach. I was looking for a simple SQL approach I could code into the C# program. Is it possible to use a parameterized query with IN?
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1143132732.883214_at_yasure.drizzle.com...
> 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)
Received on Thu Mar 23 2006 - 18:15:48 CET