Oracle Error ORA-35749: (VCHEX01) ‘character’ is not a valid hexadecimal digit.

Oracle Error Message

ORA-35749: (VCHEX01) ‘character’ is not a valid hexadecimal digit.

Reason for the Error

The text being converted contains an invalid hexadecimal digit.

Solution

Replace the character with a digit in the range 0-9 or A-F.