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
how to send multiple values of one column as a parameter
-
- Participant
- Posts: 7
- Joined: Wed Mar 09, 2011 1:12 am
-
- Participant
- Posts: 7
- Joined: Sun Apr 10, 2011 11:30 am
- Location: Delhi
Re: how to send multiple values of one column as a parameter
Hi!
You can send anyone of the values(0 or 4 or 5) through a parameter.
Do you want to send all the values at a time?
You can send anyone of the values(0 or 4 or 5) through a parameter.
Do you want to send all the values at a time?
-
- Participant
- Posts: 7
- Joined: Wed Mar 09, 2011 1:12 am
Re: how to send multiple values of one column as a parameter
i want to send multiple values as parameter to the web service..as my reqmt.is i need to fetch the data where severity IN(0,4,5) and this will be mapped to severity column of receiving system and should receive the corresponding data matching this condition