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

Home -> Community -> Mailing Lists -> Oracle-L -> Insert > 8000 Byte into LONG column

Insert > 8000 Byte into LONG column

From: Guido Konsolke <Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com>
Date: Wed, 16 Jul 2003 14:57:20 +0200
Message-Id: <25937.338008@fatcity.com> 





Hi dear list members,



we run a database 8.1.6.2


I've run into a problem. I've got a table that
contains a LONG column (I know, I know).
I have to insert a string into it that has a length > 8500 Byte.
Whenever I issue the insert statement SQL/PLUS throws
the error 'ORA-01704: string literal too long'.



Does anyone have an idea how I can get the data
into the table?



Any help (except: change the datatype ;-)) is appreciated.



Greetings,
Received on Wed Jul 16 2003 - 07:57:20 CDT












Original text of this message













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