From: ajung@suxers.de
Subject: Re: How to insert into clob's????
Date: 2000/07/04
Message-ID: <150e.3961f1e2.e79c0@yetix.sz-sb.de>#1/1
References: <Wxj85.19$si6.857@news101.telia.com>
X-Complaints-To: abuse@online.de
X-Trace: news.online.de 962721001 31266 212.184.137.153 (4 Jul 2000 14:30:01 GMT)
Organization: YETIX Magic Suxer Schnuckie Bastard Site
User-Agent: tin/1.5.4-20000523 ("1959") (UNIX) (Linux/2.2.16 (i586))
Reply-To: ajung@suxers.de
NNTP-Posting-Date: 4 Jul 2000 14:30:01 GMT
Newsgroups: comp.databases.oracle.tools


John Heinrich <jhr@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