I have a context variable PERIOD_YEAR and when I am using this variable in my source input SQL as below.
"SELECT C1,C2 FROM <ABC> WHERE PERIOD_YEAR = '"+context.PERIOD_YEAR"'"
when I am executing my ETL job, 'tOracleInput' object is throwing error as below
'java.sql.SQLSyntaxErrorExecution: ORA-01722: invalid number'
Please provide your input to resolve the issue.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema