Loading

Error "failure Evaluating To Database: Oracle Database Error 1858" Upon Running The Flow

Publiceringsdatum: May 1, 2025
Beskrivning

Upon running the flow with Oracle data source, the following error occurs:

"Failure evaluating to database: Oracle database error 1858: ORA-01858: a non-numeric character found where a numeric was expected Try running the flow again or review the log file for more details."



 

Cause

The input data to be converted using a date format model is incorrect. The input data did not contain a number where a number was required by the format model.
Lösning
1. Fix the input data to conform to the format which is used in the flow.
or
2. Correct the date format model in the flow to ensure that the elements match in number and type in the database.
Ytterligare resurser
For example,

1)
SQL> select to_date(’10-JUN-2014’, ‘DD-MM-YYYY’) from dual;
ERROR:

ORA-01858: a non-numeric character was found where a numeric was expected
no rows selected

2)
SQL> select to_date(’10-JUN-2014’, ‘DD-MON-YYYY’) from dual
2 /
TO_DATE( ‘ 10
10-JUN-2014

This allows the statement to run smoothly.

Knowledge-artikelnummer

001534403

Bilagor

error.png

10 KB

 
Laddar
Salesforce Help | Article