wm_concat function and small characer buffer
- by Ruslan
Hi,
i have select like:
select substr(account,1,4), currency, amount, module,count(*) quan, wm_concat(id) ids from all_transactions group by substr(account,1,4), currency, amount, module
But sometimes COUNT(*) is more then 600. In that case i get:
'ORA-06502: PL/SQL: : character string buffer too small'
Is there any way out to keep wm_concat(id) for all records?
Because excluding this function for entries with big COUNT(*) is the way out.
