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

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. Received on Thu Feb 03 2000 - 10:29:57 CST