Copying LONG RAWs between tables

Is it possible to copy a LONG RAW value between two different tables in Oracle 8.0.5(presumably using PL/SQL and doing it in 32k chunks)? I've seen this done with >32k LONG values, but not LONG RAWs.

And yes, I know that Oracle 8 BLOBs can do this. However, our software environment prevents us from properly loading data into BLOBs. In addition, the application and database are connected via a WAN, so copying the data down to the client and re-uploading it (which is what we currently do) is also not an option. We really need a way to move from LONG RAW to LONG RAW without leaving the database.

It would be acceptable if we could take a single LONG RAW and copy it into another table in 32k increments (multiple rows for the whole file).

Any suggestions?

• Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****