Oracle Error ORA-09820: Conversion of class string to numeric representation failed.

Oracle Error Message

ORA-09820: Conversion of class string to numeric representation failed.

Reason for the Error

ORACLE was unable to convert a class string to a number because all of the characters in the string were not numeric.

Solution

Change the string to be either all numbers or all non-numeric characters and repeat the conversion.