Talend-Unable to use Context variable in oracle query

Question

I am facing challenge in calling a context variable in my oracle source query

select branch_code from sttms_branch where country_code='"+context.con_contry_cd+"'

No rows are fetching.But if we hardcode instead of context.con_contry_cd,then it is working fine I tried the double quotes at start of select and all possible permuation combinations but nothing is working out.But the context variables are working fine in tmap stage.I am totally stuck up with this issue.Please help!

score 0 · Accepted Answer · answered May 04 '17 at 21:20

0

The exact code must be "select branch_code from sttms_branch where country_code='"+context.con_contry_cd+"'" or you will get a compilation error. Also verify the exact value of the context variable (be carefull at white spaces which can be a possible cause of the problem).

Hope this helps.

answered May 04 '17 at 21:20

TRF

791
4
9

Yes TRF,The issue was with the quotes now it got fixed thanks a lot – NMB May 05 '17 at 14:56
Don't hesitate to mark the question as solved ;) you may also give 1 point ;)) – TRF May 05 '17 at 17:05

Talend-Unable to use Context variable in oracle query

1 Answers1