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.
 

Category: Database

Tags:

Leave a Reply

Article by: Shadab Mohammad