Hi All,
I’m using a Classic Report with column headings generated through a PL/SQL Function Body (as per the sample code below),
DECLARE
v_headers VARCHAR2(4000);
BEGIN
SELECT LISTAGG(text, ':') WITHIN GROUP (ORDER BY text)
INTO v_headers
FROM sample_table;
RETURN v_headers;
END;
but I am getting the following error:
I checked that v_headers exceeds the 4000 but what should I do here to fix the issue, I tried clob but no luck. Any suggestion please