SQL & PL/SQL

Hi ,

i am trying to insert 4000 character in one of the cloumn but still getting error that string is too long.

here what i did,

create table Test (meassage CLOB);

where CLOB is a datatype and message is column name.

now i am trying to insert into message(column) more that 4000 character data but still i am getting error STRING TOO LONG.


so i am not sure where i am wrong?


can you please assist me on that .... thanks in advance..



thanks...................