Re: How to insert into clob's????

John Heinrich <jhr_at_tidk.dk> wrote:
2qy
2qyWhen I try to insert a large text (> 10000 char) into a clob-column, I get 2qythe following error:
2qy
2qy"ORA-01704: string literal too long." 2qy
2qyWith a text smaller than 4000 characters, there are no problem. 2qy
2qyI created the table with the following: 2qy
2qycreate table lob_tab (id number, a_lob clob 2qylob (a_lob) store as (tablespace lob_ts chunk 4096). 2qy
2qyHow do I insert large objects into a lob???

I think this problem is releated to SQL/PLUS. We are using e.g. stored procedures written in Java so we got rid of most PL/SQL and SQL/PLUS problems.

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