Is there a workaround for returning Memo column in a cursor like the one below?
SELECT PADR(category_id, 255) FROM product_category
INTO CURSOR or INTO ARRAY makes no difference.
Through using UNION ALL I was able to create Memo column in the resulting cursor. Still failed to fill that column with anything longer than 254 characters. Neither PADR() nor inline function worked.
The function below perfectly works as a stand-alone. Once placed in SQL SELECT statement, it causes "String is too long to fit" error.
FUNCTION GetLongString(cSource)
RETURN PADR(cSource, 255)