Listagg Function Resulting In ORA-01489 Error
(Doc ID 2590979.1)
Last updated on SEPTEMBER 23, 2019
Applies to:JDBC - Version 10.2.0.2 and later
Information in this document applies to any platform.
SQL report using listagg function results in error:
ORA-01489: result of string concatenation is too long.
There is a requirement to display all the Offering Titles associated to a Course. Hence, Listagg function is used for one of the columns. All Titles are to be displayed even if the length is going beyond 2000 characters.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document