Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data load for CLOB datatype
You have to use the LOB package. I think its lob.write. I cant remember. Its
on OTN though.
"weiwei" <xiaw_at_cbmi.upmc.edu> wrote in message
news:b7696273.0204151241.3d042588_at_posting.google.com...
> 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
Received on Mon Apr 15 2002 - 20:16:50 CDT