Re: Copying LONG RAW into BLOB fileds

How big is the table?
Try imp from old exp to new and work on it there as a workaround.

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 - 11:05:51 CST