title: How to pass a list of values to one Oracle Report parameter?
body: <p>I have one parameter (parameter_in) in my Oracle Report Builder, I am using this parameter in following query in this report but the result is not appear.
  My name parameter is  <strong>(mhn.kod_urusan IN (replace(:p_kod_urusan,'[^,]+',',') ) or  :p_kod_urusan is null)</strong> 
  This my query:-</p>
  
  <pre><code>select distinct to_char(mhn.trh_masuk,'dd/mm/yyyy') trh_masuk,
  p.nama nama,mhn.kod_urusan
  
  from mohon mhn,mohon_hakmilik mh, pemohon pm, pihak p, 
  hakmilik h,
  kod_daerah kd,kod_bpm kb
  where 
  mhn.id_mohon = mh.id_mohon
  and mhn.id_mohon = pm.id_mohon
  and pm.id_pihak = p.id_pihak(+)
  and mh.id_hakmilik = h.id_hakmilik
  and h.kod_daerah = kd.kod(+)
  and (upper(TRUNC(mhn.trh_masuk)) BETWEEN :p_date1  AND :p_date2 )
  and (mhn.kod_urusan IN (replace(:p_kod_urusan,'[^,]+',',') ) or  :p_kod_urusan is null)    
  order by  1 asc
  </code></pre>
  
  <p>Anyone got the idea?.:(:( </p>