Context Variable with Date Parameter : How to use?

[Anonymous]

Hi all, 

I'm having a problem using my context variable in sql builder in tDBInput . 

Here is my context variable 

Here is how I use the variable in SQL 

WHERE TO_CHAR(CREATE_DT,'YYYY-MM-DD') = TO_CHAR('+context.PARAMETER_DATE+','YYYY-MM-DD')

but once I run my job I receive "ORA-01722: invalid number" error. 

Please help me . Hope you understand what I'm trying to reach out have a great day! 

[manodwhb]

@iMinari17 , the best way to know the what value and the query is passing to io check that in tJava print the query which is trying to use in tdbinput.

your query construction would wrong with context variables. something like this you need use check the below.

"select * form table WHERE TO_CHAR(CREATE_DT,'YYYY-MM-DD') = TO_CHAR('"+context.PARAMETER_DATE+"','YYYY-MM-DD')"