Thanks Santy.
I'm getting the error when I assign the whole 32k string without the concat
operator (||) to local variable longVal. Is there a way around for that?
SP
"santysharma" <santysharma_at_hotmail.com> wrote in message
news:a3um1q$1au9ko$1_at_ID-84096.news.dfncis.de...
>
> "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 - 14:17:38 CST
