Re: ORA-01704 and SP2-0027 errors

"Sunil Pant" <spant_at_eline.com> wrote in message news:0FA88.711$1F2.16553_at_sea-read.news.verio.net...
> 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
 ok, i said pl/sql..
try this test
SQL> create table test1
  2 ( col1 long);

Table created.
  create or replace procedure insertlong as   2 longval varchar2(32000);
  3 begin
  4 longval := 'a';
  5 for i in 1..30000
  6 loop
  7 longval := longval || 'a' ;
  8 end loop;
  9 dbms_output.put_line (length(longval));  10 insert into test1 values (longval);  11* end;
SQL> /
Procedure created.
set long 100000
set serveroutput on
exec insertlong
30001
select * from test1; Received on Thu Feb 07 2002 - 13:54:14 CST