Re: What is Secret to inserting >4000 chars into a CLOB column?

Look at the dbms_lob package.
lobs hold up to 4 gig.
Jim
"Steve" <streesh_at_bellsouth.net> wrote in message news:ser%7.4498$GP2.172052_at_e3500-atl2.usenetserver.com...
> I've got a requirement to store large streams of postscript text
> representing documents. I've
> tried all the LOB types and can't get a simple insert to work. I tested
 it
> using the following
>
> CREATE TABLE CLOB_TEST
> (DUMMY CLOB);
>
> INSERT INTO CLOB_TEST
> (DUMMY)
> VALUES ( );
> ^--- Long string here.
>
> Any string longer than 4000 yields an ORA 1704 - String literal too long
>
> I need to store documents that are 50,000 + chars. Every thing I read
> tells me the CLOB can hold > 1Gig.
>
> What can I do?
>
> I'll also need to retrieve the data with a select
>
> Thanks
>
> Steve
>
>
>
>
Received on Fri Jan 11 2002 - 03:34:26 CET