We have a query using LISTAGG to aggregate project names. This query is running fine in SQL Developer and not running when deployed as a query in Clarity.
An error is thrown:
ORA-01489: result of string concatenation is too long
Release : All Supported Clarity Versions
This is Caused because of the length of Aggregated values in LISTAGG . By default the maximum length is 4000 characters and if it exceeds this we face this issue.
Workaround: