title: Oracle Stored Procedure not working (where in string)
body: <p>Here is my entire Stored Procedure:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE "CTI"."TEMP_DIVISION"
  (
      pDivisionList in varchar2,
      out_cursor out SYS_REFCURSOR
  )
  as
  begin
    open out_cursor for
    SELECT distinct CTA_DIVISION
    FROM cti_account 
    WHERE CTA_DIVISION in (pDivisionList);  
  END;
  </code></pre>
  
  <p>If I pass in TPA, it returns TPA as 1 row (correct).  If I pass in CFL, it returns CFL as 1 row (correct). However, what I would like to do, is pass in TPA,CFL and have it run like WHERE CTA_DIVISION in ('TPA','CFL') returning 2 rows of data, but that's not happening. It's not returning any rows.  What do I need to change to be able to pass that string in and get 2 rows returned? TIA</p>