I have developed a function which will generate a dynamic SQL query for a complex Report. I have given it has CLOB output. However, When I try to call the function getting the incomplete output format. Kindly help me to sort out the issue. I have included the code for reference. this function's output is called in the APEX as a classic report.
XXBCT_CLASSIC_RPT_OUTPUT_FN_oracle.sql