Context Variable As Source SQL filter

[_AnonymousUser]

Hi,
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 
ERROR:
'java.sql.SQLSyntaxErrorExecution: ORA-01722: invalid number'
Please provide your input to resolve the issue.
Thanks
Saket Krishna 

[Anonymous]

You need to remove the single quotes from around the value held by the context variable. So instead of this....
"SELECT C1,C2 FROM <ABC> WHERE PERIOD_YEAR = '"+context.PERIOD_YEAR"'"
....try this....
"SELECT C1,C2 FROM <ABC> WHERE PERIOD_YEAR = "+context.PERIOD_YEAR