Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

jdbc receiver select and update

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

Not what you were looking for? View more on this topic or Ask a question