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!

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.

Thanks

Added on Jun 2 2020

4 comments

368 views