Re: Help:CLOB Fields length more than 4000

Hi,

You are trying to insert varchar2 constant which can not be longer than 4000 bytes. You should load clob from file. See dbms_lob package for details.

Andrew Protasov

> 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 Tue Dec 08 1998 - 03:24:58 CST