jdbc receiver select and update
i have requirement from customer with jdbc receiver select and update.
pattern is soap to jdbc(oracle) select sync.
1. i have to select with multi po number as following;
select * from EKPO where EBELN in ( po number1, po number2, ...... )
current i completed it with only one PO number1,, but coming from multiple po number, i do not know how to do it .
do i have to make key as ( 0, unbound ) in mapping target jdbc receiver select format?
oracle stored procedure is possible ? as i know, SP is called by one by one call.
if not possible, what about oracle function?
2. new question. ( soap to jdbc sync select)
is there a good way ? soap to jdbc sync select with key and then update data selected scenario ,
response data should be row table.
additional , we are using 7.31 .
thank you in advance