How to insert into clob's????

[Quoted] When I try to insert a large text (> 10000 char) into a clob-column, I get the following error:

"ORA-01704: string literal too long."

With a text smaller than 4000 characters, there are no problem.

I created the table with the following:

create table lob_tab (id number, a_lob clob lob (a_lob) store as (tablespace lob_ts chunk 4096).

How do I insert large objects into a lob???

Help would be much appreciated

John Received on Tue Jul 04 2000 - 00:00:00 CEST