Help:CLOB Fields length more than 4000

From: <goldenge_at_my-dejanews.com>
Date: Tue, 08 Dec 1998 04:13:14 GMT
Message-ID: <74i90p$u1j$1@nnrp1.dejanews.com>

Dear all. We used Oracle database server version 8.0.4. We create a table as folloing: lob_table(col1 varchar(10), c_lob clob). when we insert the values of c_lob fields more than 4000 lengths, it always occurs the following errors: ORA-01704: string literal too long. Then I create the table as this; CREATE TABLE lob_table (col1 varchar(10) col2 CLOB NULL) STORAGE ( INITIAL 6K NEXT 4K MAXEXTENTS 121 PCTINCREASE 20) TABLESPACE "GOLD" LOB( col1) STORE AS ( TABLESPACE "LOB_STORE" STORAGE ( INITIAL 6K NEXT 4K MAXEXTENTS 121 PCTINCREASE 20) DISABLE STORAGE IN ROW ); It also get the above errors.

Dose anyone can help me solve this problems? Thanks you very much.

E-Mail:goldenge_at_chinasystems-cn.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 22:13:14 CST