This is probably not the best solution, but I broke down the strings to
sub-4000 char pieces and used the || operator as in:
insert into foo values('a really' || 'long string');
<> wrote in message news:852lr1$655$1_at_nnrp1.deja.com...
> Hello all,
>
> This sounds like a newbie question:) How do you insert a large amount
> of text into a LONG column? Oracle keeps giving complaining the insert
> string is two long. The Oracle reference says this:
>
> ORA-01704: string literal too long
> Cause: A quoted string specified as a constant was too long.
>
> Action: Quoted strings may not contain more than 2000 characters.
>
> Then how in the heck do you load data into a column that's supposed to
> hold 2GB or char data???!!!
>
> Thanks to all!
> --Dan
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jan 09 2000 - 18:39:56 CST
