problem insert on clob field

Hi,

I have a problem inserting a clob field in a database table. My table

create table T1(id int, xmlmsg clob);

when I do an insert on this table with a big xmlmsg i get an error that he string literal is too long.

My sql code

insert into T1(id, xmlmsg) values(1, 'her comes a very big xml string');

gives me the oracle error. How can I insert my xmlmsg column.

thanks

John Received on Tue Jan 16 2007 - 10:10:32 CST