Moving Long Raw data between tables

Does anyone know the easiest way for moving a column of LONG RAW data in one table to a column of LONG RAW data in another, using 7.3.3.

I started using PL/SQL in a simple procedure to basically copy rows from one table to the other via a cursor loop.

However, it appears the data is concatenated to 32K, which I presume is because of the long variable limit in PL/SQL.

The code I currently have is:

create or replace procedure migrate
is
begin
  for c in

     (select data from table1)
  loop

  insert into table2

(new_data)

  values

(c.data);

  end loop;
end;

where data is the LONG RAW column.

Daren

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 22 1999 - 10:09:27 CDT