title: problem using Oracle parameters in SELECT IN
body: <p>I have a problem when inserting a string of numbers into sql query</p>
  
  <pre><code>  SELECT * 
      FROM tablename a 
     WHERE a.flokkurid IN (3857,3858,3863,3285) 
  ORDER BY sjodategund, rodun 
  </code></pre>
  
  <p>...or:</p>
  
  <pre><code>  SELECT * 
      FROM tablename a 
     WHERE a.flokkurid IN (:strManyNumbers) 
  ORDER BY sjodategund, rodun 
  </code></pre>
  
  <p>...with this code:</p>
  
  <pre><code>using (OracleCommand sel = new OracleCommand(SQL, connectionstring)) {
    sel.Parameters.Add(":strManyNumbers", 
                        OracleDbType.Varchar2, 
                        "Client",
                        ParameterDirection.Input);
  }
  </code></pre>
  
  <p>So if i run this query i get:</p>
  
  <blockquote>
    <p>ORA-01722: invalid number</p>
  </blockquote>
  
  <p>but if i insert just one number, i.e. "3857" it will return query OK with data.</p>