By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select
x,
-BITAND(utl_raw.cast_to_binary_integer(hextoraw(x)),32768)
+BITAND(utl_raw.cast_to_binary_integer(hextoraw(x)),32767) result
from (select '8508' x from dual);
| X | RESULT |
|---|---|
| 8508 | -31480 |