Re: ORA-01704 and SP2-0027 errors. Help!!!

Use CLOB, not LONG.
Have you considered a BFILE?

Sunil Pant wrote:

> I need to migrate text data from SQL sever to Oracle 8.1.7. When I tried to
> do-- insert into table_name (textfield) values ('a big textdata..'), it gave
> me error--ORA-01704: string literal too long. I tried to insert using
> PL/SQL and I got the following error:
> SP2-0027: Input is too long (> 2499 characters) - line ignored. What could
> be the solution to this problem? textfield column is of long data type in
> Oracle 8.1.7.
> Thanks for any help.
> SP
>
>
>
>
Received on Wed Feb 06 2002 - 19:10:13 CST