Loading

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

Udgivelsesdato: May 1, 2025
Beskrivelse

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.
Yderligere ressourcer
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.

Vidensartikelnummer

001534403

Vedhæftede filer

error.png

10 KB

 
Indlæser
Salesforce Help | Article