Last updated on JULY 05, 2017
Applies to:PL/SQL - Version: 220.127.116.11 to 18.104.22.168 - Release: 9.2 to 11.2
Information in this document applies to any platform.
numeric or value error: hex to raw conversion error' may occur for some PL/SQL
blocks when conversions from raw to long, or vice versa, are performed.
These errors continue to occur even when event 10943, level 1048576 is set,
in an attempt to disable the fix for <bug 2004646>, e.g
alter session set events '10943 trace name context forever, level 1048576';
x long := 'hello world';
y raw(40) := x;
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at line 3
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms