| 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:
|
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.
