Oracle / PLSQL: ORA-01858 Error Message

Learn the cause and how to resolve the ORA-01858 error message in Oracle.

Description

When you encounter an ORA-01858 error, the following error message will appear:

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

Resolution

The option(s) to resolve this Oracle error are:

Option #1

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