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.

Knowledge 기사 번호

001534403

첨부 파일

error.png

10 KB

 
로드 중
Salesforce Help | Article