title: Oracle PLSQL update table where in Associative Array?
body: <p>I would like to, in a stored proc, update all the records that match an id. 
  Now, this list of id, is being passed in as a table of varchar (Associative Array)..</p>
  
  <pre><code>CREATE TYPE varcharArray AS TABLE OF VARCHAR2(1000) index by ...
  </code></pre>
  
  <p>and the proc declaration is something like</p>
  
  <pre><code>PROCEDURE testProc (p_IDs in varcharArray, p_Success out Number)
  </code></pre>
  
  <p>and the update statement in the proc</p>
  
  <pre><code>update testtable 
  set col = 'val' 
  where id in (select column_value from table(p_IDs);
  </code></pre>
  
  <p>This doesn't seem to work. So i had to do a loop in the array and update for each Id. </p>
  
  <p>But i'd really like it to update using the where in clause.. Any help would be great.</p>
  
  <p>PS: the id field is a number.</p>