Update Database Table through JDBC Adaptor
I need to update one table in Oracle by using JDBC adaptor. The sender will be the ABAP Proxy class. There are 2 fields to be updated in the Oracle table based on 5 fields. Issue is at present there are around 30-40 Update queries (Native SQL) for various type of conditions (5 fields).
Based on the where clause some time one field has to be updated or some times 2. (all these various permutations & combinations are right now happening through Native SQL queries).
Since 30-40 interfaces one each for Native SQL is not a good idea we have identified 3 different ways of doing..
1. Store all the details in an Internal Table that are required i.e 2 fields that are to be updated & 5 key fields and do all the manipulations and send back the table just for updating in the Oracle table.
2. Use XML SQL structure (using access & key ) and getting it done in the JDBC receiver.
3. Send all the details to JDBC and write a stored procedure in the Oracle (for various conditions)
At the the most at a given point of time 10-15 line items exists.
Please tell me which will be the best way out of the above 3 options (efficiency).
Thanks & Regards