ORA-01858 a non-numeric character was found where a numeric was

Error: ORA-01858: a non-numeric character found where a digit was expected
Cause: You tried to enter a date value using a specified date format, but you entered a non-numeric character where a numeric character was expected.
Action: The options to resolve this Oracle error are:

  1. Check the date formats recognized by the to_date function. Correct the date value and retry.

Solution:

This error is mostly related to DATE column. You are either trying to insert a string in a Date column. On Windows I solved this problem in my environment using the NLS_LANG parameter in registry. Check HKLM\Software\Oracle\Home… and set the NLS_LANG parameter matching with your database character set.

 

Leave a Reply