Could someone please tell me how to insert a string longer than 255 characters
into a "long" datatype in a database?
More precisely, I have a simpe table
create table junk (
type char(25),
description long
);
When trying to insert something like
insert into junk values ('list','123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
I get an error message
ERROR at line 1:
ORA-01704: string literal too long
Thanks in advance,