title: Oracle Error : Maximum number of expressions in a list is 1000
body: <p>I am working in C#.Net and Oracle. i am passing a string to a query. i had used this code for concating all the item id's</p>
  
  <pre><code>List&lt;string&gt; listRetID = new List&lt;string&gt;();
                  foreach (DataRow row in dtNew.Rows)
                  {
                      listRetID.Add(row[3].ToString());
                  }
  </code></pre>
  
  <p>This concatination goes above 10,000. so i am getting the error message like this..</p>
  
  <pre><code>ORA-01795: maximum number of expressions in a list is 1000
  </code></pre>
  
  <p>How to fix this..</p>