WM_CONCAT use CASE
- by Ruslan
i have a select:
select substr(acc,1,4),currency, amount, module, count(*), wm_concat(trn_ref_no) trn
from all_entries where date = to_date ('01012010','DDMMYYYY')
group by substr(acc,1,4),currency, amount, module
in this case i have error: *ORA-06502: PL/SQL: : character string buffer too small ... "WMSYS.WM_CONCAT_IMPL"*
if i change to:
select substr(acc,1,4),currency, amount, module, count(), (case when count() < 10 then wm_concat(trn_ref_no) else null end) trn
from fcc.acvw_all_ac_entries where trn_dt = to_date ('05052010','DDMMYYYY')
group by substr(acc,1,4),currency, amount, module
to avoid buffer limit error. But even in this case i have the same error.
How can i avoid this error?
