Insert large strings per sqlscript in clob field

Hallo,

we have a databasetable in a Oracle 9.2 Database. This table has an CLob field for xml-Settings. The length of the xml string can be various between 2000 and > 10000 chars. We want to insert any datarecords per sql script. The script can executed in SQL Plus whitout a problem and without a errormessage. But when we check the length of the content of the clob field, then the length is diferrent to the awaited size.

We don't know where the problem is.

The synax for the insert statement was :

update table set xmlfield = '<xml>
...
</xml>' where idfield = @id

-- 


Beste Grüße

Jan