Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01489: result of string concatenation is too long --

S567Jun 2 2020 — edited Jun 2 2020

Hi Team,

I am working for oracle 11g.

I have a table with around 200+ columns.

I have a requirement to aggregate the data an d later export the file.

While using list aggregate i am facing below error, Can you please advise how can we handle are there any functions which can handle around 4000 CHAR.

pastedImage_1.png

pastedImage_0.png

Thanks
Comments
Post Details
Added on Jun 2 2020
4 comments
322 views