Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: data load for CLOB datatype

Re: data load for CLOB datatype

From: Lee M Horowitz <lee_at_JamToday.com>
Date: Wed, 15 May 2002 16:18:24 -0400
Message-ID: <2bg5eug73idl0hdqp9r0fht683kt3vvnus@4ax.com>


On 15 Apr 2002 13:41:05 -0700, xiaw_at_cbmi.upmc.edu (weiwei) wrote:

>Hi,
>
>I have a column having datatype CLOB. I tried to load data to that
>column and get the error message which is "ORA-01704 string literal
>too long". Ichecked oracle web site which explain as below:
>ORA-01704 string literal too long
>Cause: The string literal is longer than 4000 characters.
>Action: Use a string literal of at most 4000 characters. Longer values
>may only be entered using bind variab
>
>My data is more than 4000 characters. But I know CLOB can hold up to
>4GB in length. Can anybody tell me why I can't load data to that
>column?
>
>Any help will be very appreciated.
>
>Thanks
>wei

How were you trying to load the CLOB?
Through sql loader? Using dbms_lob? XSU Utility? Large hammer? What?

What code or script caused the problem?

You can try tahiti.oracle.com (RTFM)....look for keywords such as LOB, or the package DBMS_LOB, or SQLLDR (Sql loader).

There are plenty of examples of how to load a CLOB, but without your code example, how can we tell what you're doing that Oracle doesnt like? Received on Wed May 15 2002 - 15:18:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US