Cause: ORACLE was unable to convert a class string to a number because all of the characters in the string were not numeric. See the solution below.
Error solution: Change the string to be either all numbers or all non-numeric characters and repeat the conversion.
Database version: Oracle 11g Release 2 (11.2)