Fighting the 32K limit

Using Oracle 8.0.5

Using PL/SQL, is there any way to take a couple of pieces of text, the sum total of which is longer than 32K, and concatenate it and put the result into a LONG?

So far, I don't see any way of doing it.

I was just thinking, though, that I could certainly put them into a CLOB in a new temp table, but would it be possible to move it into a LONG from there? Received on Sun Jul 18 1999 - 10:44:20 CDT