title: How can I collect multiple values into an array and later use the array with IN clause
body: <p>I need to do this inside a stored procedure in Oracle 10g/11g:</p>
  
  <pre><code>SELECT COLUM1 INTO SOME_ARRAY FROM TAB1 WHERE COLUMN2=P_COL2;
  </code></pre>
  
  <p>And then I want to be able to use that SOME_ARRAY in another query with IN clause, like this:</p>
  
  <pre><code>SELECT * FROM TAB2 WHERE TAB2.COLUMN1 IN SOME_ARRAY
  </code></pre>
  
  <p>Is this possible without needing to create a TYPE? Maybe a dynamic array? A little code will be appreciated.</p>