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 -> copying long data from SQL server to Oracle 8.1.7

copying long data from SQL server to Oracle 8.1.7

From: Sunil Pant <spant_at_eline.com>
Date: Fri, 01 Feb 2002 00:48:02 GMT
Message-ID: <6Bl68.342$1F2.6864@sea-read.news.verio.net> 





I need to migrate text data from SQL sever to Oracle 8.1.7.  When I tried to
do-- insert into (textfield) values ('a big textdata..'), it gave me
error--ORA-01704: string literal too long.  I tried to insert using PL/SQL
but that it limited to 32k.  What is the solution if the data is more than
32k?



Thanks for any help.


SP
Received on Thu Jan 31 2002 - 18:48:02 CST












Original text of this message













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