in article 2bg5eug73idl0hdqp9r0fht683kt3vvnus_at_4ax.com, Lee M Horowitz at
lee_at_JamToday.com wrote on 15/05/02 22:18:
> 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?
>
>
>
I've read something about CLOBs, that they either can be stored as
"In-table" or "out of table"... In-table is limited to 4000 chars, out of
tables demands a Clobs tablespace (or something like that)....
Received on Thu May 16 2002 - 06:49:21 CDT
