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

Home -> Community -> Usenet -> c.d.o.server -> Insert a long field

Insert a long field

From: John Ma <john_ma_at_hp.com>
Date: Thu, 25 Jun 1998 11:19:12 -0700
Message-ID: <359294A0.769E@hp.com> 





Hi,



Currently, we have a "long" field in the table, and need to insert data
into it.  I used "insert", but I got the error message: 



ORA-01704: string literal too long




As I know Oracle 7.3 support "long" up to 2GB, does anyone know what I
should do/set to break the limitation?  and What is the limitation? Does
there has some special setting I need to do if I use sqlloader to do
initial loading?




Thank you very much for the help.





John
Received on Thu Jun 25 1998 - 13:19:12 CDT












Original text of this message













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