jdbc receiver select and update

[former_member229036]

Hi all;

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;

   source data

          row(0, unbound)
               PO number

   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

[former_member184720]

Make use of SQL_DML format and define place holder to make your select query dynamic.

Defining an SQL_QUERY Statement - Configuring the JDBC Adapter in the Integration Directory/PCK - SA...

[former_member229036]

Thank you feddback,

but what if po number  increasing,  does not make  sense  to use SQL_QUERY.