title: Pass Comma Separated String to IN clause in stored procedure
body: <p>I am having comma seperated String and i am passing this comma seperated to oracle stored procedure. Now how to handle this string in cursor to IN clause.</p>
  
  <pre><code>String codes = "ABCD','EEFF','GGHH";
  </code></pre>
  
  <p>And cursor query is like </p>
  
  <pre><code>    CURSOR cur_bill_cod
     IS
        SELECT a.*
    FROM bill_codes a
   WHERE a.code in (p_codes)  ;
  </code></pre>
  
  <p>I declared p_codes as varchar in procedure.</p>
  
  <p>But it is not fetching records.  I tried string passing in another way as</p>
  
  <pre><code>String codes = "ABCD,EEFF,GGHH";
  </code></pre>
  
  <p>But in both the ways it failing and it is not throwing any exception.
   Could you please help me out on this.</p>