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

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 - 16:49:27 CST