title: Pass a list of integers from C# into Oracle stored procedure
body: <p>I have a oracle stored procedure which updates a table with the following statement.</p>
  
  <pre><code>update boxes 
  set    location = 'some value'
  where  boxid = passed value
  </code></pre>
  
  <p>I have a page where the user selects 100+ boxes and updates them with a new location value. Currently, I have to call the stored procedure 100+ times to update each box(by passing a boxid each time).</p>
  
  <p>I want to know how I can pass a list of boxids from <code>C#</code> into the stored procedure so that I have to call the stored procedure just one time.</p>
  
  <p>I am hoping to use a <b>where in(boxids)</b> kind of where clause in the update statement.</p>
  
  <p>Please let know how can I achieve this. Thanks in advance!</p>