AnsweredAssumed Answered

How to pass multiple values as parameter input to oracle connector using process property

Question asked by hemalatha.ediga793658 on Feb 21, 2017
Latest reply on Feb 23, 2017 by eric.haycraft662300

my requirement is select * from emp where where company in (?)

value to company parameter to be passed as extension value as array('dept1','dept2',...), ideclare a process property and mapped DB connector parameters

 

 and i am trying to pass values through PP 

process is not moving forward from DB connector shape, not getting any response though i have data for the defined values, able to get response when i try with single value as input (select * from emp where where company in (0301))

 

I can not create multiple properties as I have 300 company codes to be validated

Outcomes