title: Oracle PL/SQL - how to use table of varchar in select statement?
body: <p>I have a table type declared as</p>
  <pre><code>TYPE t_table IS TABLE OF VARCHAR2(15) INDEX BY PLS_INTEGER;
  </code></pre>
  <p>I am trying to use it in a procedure with a select statement, but it does not work:</p>
  <pre><code>procedure get_something (
      p_in_list  IN  t_table,
      p_out_list OUT t_table
  )
  IS
  BEGIN
      SELECT item 
      BULK collect into p_out_list 
      from my_table 
      where myrow in (select * from table(p_in_list));
  END get_something;
  </code></pre>
  <p>How can I use this in a select ... in statement?</p>