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 -> Inserting into a LONG datatype

Inserting into a LONG datatype

From: Sean Dolan <dolans_at_stripe.Colorado.EDU>
Date: 5 Jan 99 15:25:16 GMT
Message-ID: <dolans.915549916@stripe.Colorado.EDU> 





I have a table that has a LONG datatype column.  I have an SQL statement
that has a very long string (3200 characters to be exact), but when I try to
insert it into the table, I get an ORA-01704: String too long error.



How do I get a very long string into a LONG datatype through an SQL
statement?



Thanks,


Sean Dolan


sean_at_3si.com

Received on Tue Jan 05 1999 - 09:25:16 CST












Original text of this message













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