My Oracle Support Banner

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.

Symptoms

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.

Changes

 

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
Changes
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.