Re: Fighting the 32K limit

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Mon, 19 Jul 1999 19:47:20 +0100
Message-ID: <7mvods$bl1$1@news.inet.tele.dk>

Why not use a Character Large OBject (CLOB) instead? Compared to LONGs you can have multiple xLOB columns per table, full table scan isn't slow, you get a file-like interface to the data, etc.

HTH. Finn

<dogbert_at_myremarq.com> wrote in message news:OEauOST0#GA.296_at_nih2naaa.prod2.compuserve.com...
> 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 Mon Jul 19 1999 - 13:47:20 CDT