Re: How to append data to a long datatype?

If your new concatenated LONG Datatype length is less than 2000 characters in  length, you can use PL/SQL to retrieve the data into a cursor and then insert  the new lengthened long datatype into a new table. Then just drop the old  table and rename the new table.

 If the overall data length is greater than 2000 characters, you need a higher  version of Oracle which has some built-in Long datatype parsing procedures OR  you will need to concatenate the data outside of Oracle and reload the table.  

Cliff
(noodles_at_aol.com) Received on Fri Nov 14 1997 - 00:00:00 CST