title: Oracle Parameters with IN statement?
body: <p>Got a c#.net app which I need to modify. The query at the moment effectively does this:</p>
  
  <pre><code>select * from contract where contractnum = :ContractNum
  </code></pre>
  
  <p>(very simplified, just to show we're using an = and one parameter)</p>
  
  <p>That parameter is read in from the Settings.Settings file on the C# app and has one string in it.  I need to modify it to include multiple contracts, so I figure I can change the SQL to:</p>
  
  <pre><code>select * from contract where contractnum in (:ContractNum)
  </code></pre>
  
  <p>but that returns no results, no matter how I format the string in the parameter.</p>
  
  <p>Is there a way I can get oracle to do an IN with a parameter?</p>