SQL & PL/SQL

Hi ,

               I am facing listagg overflow than 4000 bytes issue in listagg , so I created a user defined aggregated function suggested by ask tom Team,

https://asktom.oracle.com/pls/apex/f?p=100:11:0%3a%3a%3a%3aP11_QUESTION_ID:2196162600402

But I am facing error like "numeric or value error: character string buffer too small" in the Type at line 27  when query this way

select stragg(val) from dummy_tab;

My table has one column and data type is varchar2(50) and it has more than 300 records,

any one can help me out here to sort out this problem.

Thanks & regards

Guru