PL/SQL (MOSC)

MOSC Banner

in case of the result is more than the maximum size, how could someone process?

edited Oct 5, 2020 8:15PM in PL/SQL (MOSC) 4 commentsAnswered ✓

I'm trying to concatenate, two values that are the same field but in different rows, with a query like this "SELECT BB.EMPLID, LISTAGG(AA.DESCR,', ') WITHIN GROUP (ORDER BY AA.DESCR) AS DESCR_CICLO_CRSADO FROM PS_TERM_TBL AA".

when trying to compile this it throws me an error that goes like "result of string concatenation is too long 

Cause: String concatenation result is more than the maximum size.

Action: Make sure that the result is less than the maximum size."

If anyone can tell me another way to do it or how to put this query together so I don't get this error message.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center