title: Character string buffer too small ORA-06512: at "WMSYS.WM_CONCAT_IMPL", line 30
body: <p>I have tried to  group the multiple rows into a single rows using <code>WM_CONCAT</code> function using <code>Oracle 10g</code>.</p>
  <p>But when running my query, I am getting the following error:</p>
  <p><strong>ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at &quot;WMSYS.WM_CONCAT_IMPL&quot;, line 30
  06502. 00000 -  &quot;PL/SQL: numeric or value error%s</strong></p>
  <p>Output of my query is :</p>
  <p>5319|   64764011907| <code>6893,1109,1120,1297,1327</code> (<strong>Need Comma separated list of store for a client id</strong>)</p>
  <p>I will not be able to create the types- lack of previliges.</p>
  <p>Please let me know if I can do the grouping using some different method in Oracle 10g.</p>