Quote Originally Posted by balajiyes
Can you please let me know why oracle failed to convert the number into character?
If you looked up the error message, you would understand why:

ORA-01722 invalid number

Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal