Copy rows with LONG RAW

I try to copy rows with LONG RAW column.

Of course, INSERT...SELECT... won't work, i tried.

Then I do is :
FOR C1 IN (SELECT LONG_RAW_COL FROM TABLE_A) LOOP   INSERT INTO TABLE_B VALUES(C1.LONG_RAW_COL); END LOOP; It works, but only for < 64K, not max. 2G of LONG RAW column.

I also try to declare a long raw PL/SQL variable and do simple manupulations, same case also happen.

Anybody know why and have a solution ?

Thx. Received on Sun Nov 22 1998 - 23:06:30 CST