title: Array in IN() clause oracle PLSQL
body: <p>I am passing String array(plcListchar) to Stored Procedure, i would like to use this String array in IN() clause.</p>
  
  <p>i can not use plcListchar directly in IN() clause.
  Let me show how i am crating plcListchar  string array in JAVA.</p>
  
  <pre><code> String array[] = {"o", "l"}; 
   ArrayDescriptor des = ArrayDescriptor.createDescriptor("CHAR_ARRAY", con);
   ARRAY array_to_pass = new ARRAY(des,con,array);            
   callStmtProductSearch.setArray(4, array_to_pass);
  </code></pre>
  
  <p>for crating CHAR_ARRAY,</p>
  
  <pre><code>create or replace type CHAR_ARRAY as table of varchar2;
  </code></pre>
  
  <p>i want use plcListchar in IN clause. the following is my Stored Procedure.</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE product_search(
              status IN varchar2, 
              plcList IN varchar2,
              i_culture_id IN number,
              plcListchar IN CHAR_ARRAY,
              status_name OUT  varchar2, 
              culture_code  OUT varchar2)
  AS  
      CURSOR search_cursor IS
      SELECT p.status_name, p.culture_code
                  FROM PRISM_ITEM_cultures@prism p
                  WHERE p.publishable_flag=1 
                  AND p.isroll =0 
                  AND status = '-1'
                  AND p.plc_status IN (   );
   BEGIN
             OPEN search_cursor;
             FETCH search_cursor INTO status_name, culture_code ;
             CLOSE search_cursor;
   END;
  </code></pre>
  
  <p>Could you please suggest me how to use, if you like to suggest any other logic, it is great.</p>