Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use OracleParameter whith the IN Operator of select statement

698719Apr 28 2009 — edited Jul 10 2012
Hi,

I am having problems using the OracleParameter when used in a query with a IN operator.

Following Example:

oraCommand.Parameters.Add(":List", strMylist ); //or Array???

The SQL command:
SELECT * FROM XXX WHERE XXX.YYY IN (:List);

What datatype must the value of :List be?

regards
Stefan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2012
Added on Apr 28 2009
12 comments
21,735 views