Can you please help me to solve this issue?
Exception in component tOracleInput_1
java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or columns specification
Here is my query:
"select i.REFERENCE_NUMBER, i.INVOICE_DATE
from INVOICE i
where i.FLAG_EXPORTED = 'Y'
and i.INVOICE_DATE = to_date((java.util.date)globalMap.get(\"row8.date_fin\"),'yyyy/mm/dd')"
This error indicates the Oracle parser thinks that one of your columns or tables is not valid. And please have a look at your code tab to see any syntax error in the INSERT statement from generated java line.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
In this video, you will see how to assign your best team members specific tasks to reconcile, correct, merge, arbitrate or group pre-determined data and achieve quality, clean data in a limited time
In this short series, you will see how Talend Data Stewardship transforms your employees into data citizens and enables them with self-service capabilities to control their quality data