title: Passing an array of strings to a procedure and using it in the WHERE clause with IN
body: <p>I want to pass a list of strings to a procedure and use it in the WHERE clause of a select statement, but I can't figure out how to do this.</p>
  
  <p>I have declared the following nested table:</p>
  
  <pre><code>TYPE t_strarray IS TABLE OF VARCHAR2(30);
  </code></pre>
  
  <p>The procedure looks as follows:</p>
  
  <pre><code>PROCEDURE getstuff(p_list IN t_strarray, io_cursor OUT t_cursor)
     IS    
     BEGIN
          OPEN io_cursor FOR
              SELECT * FROM mytable 
              WHERE mytable.field1 in (select * from table(p_list)); 
     END;
  </code></pre>
  
  <p>How can this be done?</p>