Oracle - PL/SQL - HEXTORAW Function

HEXTORAW converts char containing hexadecimal digits in the CHAR, VARCHAR2, NCHAR, or NVARCHAR2 character set to a raw value. This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.

The syntax for the hextoraw function is:

hextoraw( char )

char is the hexademical value to convert to a raw value.

Applies To:

· Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

hextoraw('45D')

would return '045D' as a raw value

hextoraw('7E')

would return '7E' as a raw value