Max length of the text I want to insert is 13k. I thought PL/SQL could
handle it. It's giving me the following error when I run that from SQL
PLUS:
SP2-0027: Input is too long (> 2499 characters) - line ignored.
SP
"santysharma" <santysharma_at_hotmail.com> wrote in message
news:a3uk8u$1b3tgg$1_at_ID-84096.news.dfncis.de...
> 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:34:20 CST
