title: PL/SQL Use Table Variable in Where Clause
body: <p>I have a table variable that is being passed into a procedure.  I would like to use the values in a where clause as below, how do I do this.  The first line below is declared in the package definition.  The procedure below is in the package body.</p>
  
  <pre><code>type CatalogNos is table of VARCHAR2(100);
  PROCEDURE GET_PART_CHARACTERISTICS (v_catalog_nos_  IN CatalogNos, 
                                      Parts_Char_Cursor out sys_refcursor) AS
  BEGIN
      OPEN Parts_Char_Cursor FOR
      SELECT * FROM IFSAPP.SALES_PART_CHARACTERISTIC
      WHERE CATALOG_NO IN (select values from v_catalog_nos_);
  END GET_PART_CHARACTERISTICS;
  </code></pre>