Concatenation question

I am attempting to put together some data to go into a LONG data field. Part of the process is to concatenate together several text strings (each with a length of around 250 characters). The problem lies in that once the length of entire concatenation goes beyond 2000 characters, I receive back an ORA-01489 error message ("result of string concatenation is too long").

Anyone have any suggestions on how I can get all this text together? Once I get it into the LONG datatype on the database I'll be fine.

THANKS!!!
*tom*
major_matt_mason_at_earthling.net Received on Mon Oct 06 1997 - 00:00:00 CEST