My Oracle Support Banner

Listagg Function Resulting In ORA-01489 Error (Doc ID 2590979.1)

Last updated on AUGUST 27, 2024

Applies to:

JDBC - Version 10.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Java application calling a SQL report that uses 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.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.