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;
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;