String Concatenation is too Long

[tokerago13]

Hi,
I'm extracting data from a temporary table that has been updated and inserted into using pl/sql. The columns are being concatenated as the data is needed as a csv file.The error I get is:
ERROR at line 1:
ORA-01489: result of string concatenation is too long.
Any ideas on how I can bypass this error message?
Thanks.
Tony

 

[Dagon]

You can't "bypass" the error message. You will have to find out which column is causing the problem and apply a function such as substr to it to prevent the error.

 

[tokerago13]

Thanks for this. I'll do that.
Regards
Tony