Re: Insert a long value ORA-01704: string literal too long

I've had the same problem with any inserts over 2000 chars. ora-01704 errors all over the place. the strange thing is this: it happens in a web-based db query program, but also in SQL worksheet. hmm...i never had problems like this with microsoft sql server...
chris

In article <87cadv$gvd$1_at_nnrp1.deja.com>,   kirche_at_my-deja.com wrote:
> hi everyone,
> i've defined a table with a LONG column to
 store text containing
> more than 4000 car.
> The problem is that when i do an insert like :
>
> insert into my_table (long_value) values
 ('patati.... patata')
>
> i have the oracle error : ORA-01704: string
 literal too long...
>
> if 'patati....patata' has less than 4000 car. :
 it's ok.
>
> What's the problem ? is it that i use quotes ?
> it seems that 'patati....patata' is considered
 like a VARCHAR2 data.
>
> thank u for help
>
> Cyril
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 29 2000 - 00:00:00 CST