how to send multiple values of one column as a parameter
Posted: Tue May 17, 2011 2:52 am
Hi,
I would like to send multiple values of one column as a IN parameter to my webservice. Like Severity IN(0,4,5) ,here severity can be 0 OR 4 OR 5.
Pls. advise how i can achieve the same.
Presently i am able to send request and receive reply for one value.
select
0 as severity
from
tab_a
Then webservice_transformer and then target_table as oracle table.
i want it as..
select
0,4,5 as severity
from tab_a (which is not correct)
Pls.advise.
Regds,
Raghav
I would like to send multiple values of one column as a IN parameter to my webservice. Like Severity IN(0,4,5) ,here severity can be 0 OR 4 OR 5.
Pls. advise how i can achieve the same.
Presently i am able to send request and receive reply for one value.
select
0 as severity
from
tab_a
Then webservice_transformer and then target_table as oracle table.
i want it as..
select
0,4,5 as severity
from tab_a (which is not correct)
Pls.advise.
Regds,
Raghav