Re: Copying LONG RAW into BLOB fileds

ah.. wait.. i believe long(s) are not supported to travel over dblink, so you'll either have to transform to blob's prior to copying over db-link, or use imp/exp and transform later.

a while back we had a table we wanted to replicate via snapshots with longs, but had to transform it to blobs in order for replication (over the link) to work.

or maybe longs just don't with snapshots .

On Fri, 11 Feb 2005 16:01:55 +0100, Ciccio <ciccio_at_ciccio.it> wrote:

>Hi,
>
>I'd need to copy pictures from a LONG RAW field in a oracle 8.0.5 db
>(OLD_DB) in a BLOB field on a oracle 9i2 (NEW_DB).
>
>When I run a stored procedure on NEW_DB that does the following:
>
>[...]
> MyPicture LONG RAW;
>[...]
> SELECT PICTURE INTO MyPictures FROM PICTURES_at_OLD_DB;
>
>I receive a ORA-01406 error (fetched column value was truncated).
>
>What can I do to overcome this problem????
>
>Thanks in advance!
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Feb 11 2005 - 13:07:31 CST