Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

listagg result of string concatenation is too long

User_AC3QEJun 10 2020 — edited Jun 15 2020

Hello I am using the listagg to concatenate some fields but it is returning 4000 exceeded, in the script below:

Result:

01489. 00000 -  "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.

This post has been answered by Solomon Yakobson on Jun 10 2020
Jump to Answer
Comments
Post Details
Added on Jun 10 2020
4 comments
5,236 views