title: Using Table type in IN-clause in PLSQL procedure
body: <p>I have a procedure which takes table type input parameter. Now I have to use this parameter in  IN-clause of SELECT query.</p>
  
  <pre><code>CREATE TYPE ids IS TABLE OF NUMBER;
  
  CREATE PROCEDURE (emp_ids IN ids) IS
  
  CURSOR IS (SELECT * FROM EMPLOYEES WHERE EMP_ID IN (SELECT * FROM TABLE(emp_ids)); .....
  </code></pre>
  
  <p>But I found that this code is not going to work because local collection types cannot be used in an SQL statement.</p>
  
  <p>Is there any alternate way to achieve using table type parameter in a SELECT statement?</p>