Loading

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

Дата публикации: May 1, 2025
Описание

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.
Решение
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.
Дополнительные ресурсы
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.

Номер статьи базы знаний

001534403

Вложения

error.png

10 KB

 
Загрузка
Salesforce Help | Article