below i have query. but i am getting this error.
how i will solve this one? want to see maximum 4000 characters because i am inserting the data to a column size is 4000.
SELECT wm_concat(e_name)|| t_name )
from test1 t, test2 R where t.tid = r.tID
ORA-22813: operand value exceeds system limits
22813. 00000 - "operand value exceeds system limits"
*Cause: Object or Collection value was too large. The size of the value
might have exceeded 30k in a SORT context, or the size might be
too big for available memory.
*Action: Choose another value and retry the operation