Re: problem insert on clob field

On Jan 16, 5:10 pm, "Bruintje Beer" <m..._at_knoware.nl> wrote:
> 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

Please post

- your version
- the actual code
- the *exact* oracle error

Your string is apparently treated as a varchar2 (4000 bytes) max.

-- 
Sybrand Bakker
Senior Oracle DBA