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