Re: Copying LONG RAWs between tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 14 Jul 1999 10:02:36 +0100
Message-ID: <931943192.8276.0.nnrp-14.9e984b29@news.demon.co.uk>

How about creating an external procedure on the server which takes the table name, column name and row id of the source,
the table name and column name of the
destination, and does the copy through
a Pro*C or OCI routine ?

Presumably you do something like this
in your 'copy to client and back' strategy so it might not be too difficult to transfer the code to the server.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

wcrawford wrote in message <931803397.24517_at_www.remarq.com>...
>Is it possible to copy a LONG RAW value between two
>different tables in Oracle 8.0.5

> 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.
Received on Wed Jul 14 1999 - 04:02:36 CDT