WM_CONCAT use CASE
Posted
by Ruslan
on Stack Overflow
See other posts from Stack Overflow
or by Ruslan
Published on 2010-05-06T08:20:31Z
Indexed on
2010/05/06
8:58 UTC
Read the original article
Hit count: 757
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?
© Stack Overflow or respective owner
