Oracle Error Message
ORA-01858: a non-numeric character was found where a numeric was expected
Reason for the Error
The input data to be converted using a date format model was incorrect. The input data did not contain a number where a number was required by the format model.
Solution
Fix the input data or the date format model to make sure the elements match in number and type. Then retry the operation.