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.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s