wm_concat function and small characer buffer
Posted
by Ruslan
on Stack Overflow
See other posts from Stack Overflow
or by Ruslan
Published on 2010-04-29T11:41:25Z
Indexed on
2010/04/29
11:47 UTC
Read the original article
Hit count: 667
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.
© Stack Overflow or respective owner
