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

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/07/04
Message-ID: <1fa4msoot79o6sv0iapbmj1jm3lf98h5dg_at_4ax.com>#1/1

You should probably look into the DBMS_LOB package, and particularly at DBMS_LOB.WRITE.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Tue, 4 Jul 2000 12:56:09 +0200, "John Heinrich" <jhr_at_tidk.dk> wrote:

>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