Re: ora 734: copying long raws via cursor truncates data..

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 17 Dec 2000 00:11:30 +0100
Message-ID: <91gsub$46gtj$2@ID-62141.news.dfncis.de>

It is truncating because you are implicitly converting to a varchar2. Check out http://osi.oracle.com/~tkyte

Hth,

Sybrand Bakker, Oracle DBA

"Jan-Erik Rosinowski" <spamfilter_at_rosinowski.de> wrote in message news:3a3bf05f.36179573_at_News.CIS.DFN.DE...
>
> we use a construct like
>
> for curs in (select longraw from mytable where id=1)
> loop
> insert into mytable(id,longraw) values (2,curs.longraw);
> end loop;
>
> our longraw gets truncated after 2000 bytes. why / how can we fix
> this?
>
>
>
> ciao, jan
>
> http://www.rsp.de/
>
> rs&p-Dossier: Geschäftsprozeßgesteuerte Schriftguterstellung.
Received on Sat Dec 16 2000 - 17:11:30 CST