Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Long Raw in Oracle 8.0

Status
Not open for further replies.

leburs

Programmer
Jan 15, 2001
5
US
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;
 
Is IMAGE_ID of numeric type? If not, use '4' instead of 4.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top