Long Raw in Oracle 8.0

[leburs]

Hi,

I need to copy LONG RAW value from one table to another.
I get ORA-06502 PL/SQL: numeric or value error

What is wrong here?

Thank you all.
Leah

-----------------------

declare
v_IMAGE long raw;

begin

SELECT IMAGE
INTO v_IMAGE
FROM IMAGES
WHERE IMAGE_ID = 4;

UPDATE OTHER_IMAGES
SET IMAGE = v_IMAGE
WHERE IMAGE_ID = 4;

end;

[sezgin]

Try to use some convertion of source Data for example to Character or hexadecimal data.
Long raw fields stored in binary format and may be the problem is here. Try to use RAWTOHEX function