| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> ORA-01704 and SP2-0027 errors
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 Thu Feb 07 2002 - 12:18:10 CST
 |
 |