Re: how to use datatype CLOB

From: <markp7832_at_my-deja.com>
Date: Fri, 25 Jun 1999 13:53:09 GMT
Message-ID: <7l01jv$4h0$1@nnrp1.deja.com>

In article <AOsc3.1752$kb3.1900603_at_dca1-nnrp1.news.digex.net>, "JYang" <Jyang_at_caci.com> wrote:
> Hi all,
> I try to insert data to the table with column data type as CLOB for
our WEB
> application. But I found that only 4000 characters were accepted.
Suppose
> CLOB could hold 4GB data. How can I insert the rest of the
characters into
> the CLOB column?
>
> (I use oracle server 8.0.5, and cold fusion 4)
>
> Thanks!
>
> Jane
>

The Application Developers Guide has about 80 pages on how to work with lob's. You would need to use the dmbs_lob package as it allows you to set the point and length of data within a lob that you select, insert, or update.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 25 1999 - 08:53:09 CDT