what is the max length of the text you want to insert? PL/SQL can handle
varchar2 of max 32K bytes.
Another option is to use JDBC which can handle all long streams using
getAsciiStream and setAsciiStream.
hth
santysharma
"Sunil Pant" <spant_at_eline.com> wrote in message
news:Cxz88.709$1F2.16463_at_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 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 - 13:23:46 CST
