What is Secret to inserting >4000 chars into a CLOB column?
From: Steve <streesh_at_bellsouth.net>
Date: Thu, 10 Jan 2002 19:31:20 -0600
Message-ID: <ser%7.4498$GP2.172052_at_e3500-atl2.usenetserver.com>
Date: Thu, 10 Jan 2002 19:31:20 -0600
Message-ID: <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 - 02:31:20 CET