data load for CLOB datatype

From: weiwei <xiaw_at_cbmi.upmc.edu>
Date: 15 Apr 2002 13:41:05 -0700
Message-ID: <b7696273.0204151241.3d042588@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 - 15:41:05 CDT