Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Insert into datatype long
How does one get a long string (around 10K) into an Oracle table using
standard SQL?
The column datatype is "long" which can hold a ton.
If the long string is passed in the VALUES statement the following error
appears:
ORA-01704 String literal too long
Is there any way to pass it in the VALUES clause?
Thanks in advance
Robert J. Sullivan
rjs_at_atl.ema.eds.com
Received on Thu Sep 11 1997 - 00:00:00 CDT