Re: copying long data from SQL server to Oracle 8.1.7

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 31 Jan 2002 21:11:57 +0000
Message-ID: <3C59B31D.FB4EBDFE@exesolutions.com>

VARCHAR2 variables are limited to 32K. VARCHAR2 fields are limited to 4K. Use a CLOB. Daniel Morgan

Sunil Pant wrote:

> 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 - 15:11:57 CST