Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data load for CLOB datatype
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