-
Long Raw in Oracle 8.0
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;
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|