Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Insert into datatype long

Insert into datatype long

From: Robert J. Sullivan <rjs_at_atl.ema.eds.com>
Date: 1997/09/11
Message-ID: <34182747.EE3E43D0@atl.ema.eds.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US