How to return huge data(more than 10Lakh characters) that is created dynamically inside the store procedure

Help Procedural SQL
3

Hi Hanson,
I am returning the string to GoLang Application.
String Length as I observed was having more than 10 Lakh Characters. But expected string length can go 10 times more than that.

Can you provide details on how to use rowset.
Here the input will be like , [{id: 1},{id:2}].
After validating the input, error string is constructed dynamically in the SP like
[{id:1, msg: ‘User is invalid’}, {id:2, msg: ‘User is not found’}]