OIC DB Adapter and REST API - Looping
1) GetProductInfo is using DB Adapter named 'Product Information' to get all the rows from Oracle database; results are fetched using SQL statement based on the conditions.
2) Based on the rows returns from database and response, attributes are mapped to RequestProductDetails named 'ProductTransactionDetails' REST API
3) Based on the response from REST API (ProductTransactionDetails), values are mapped to UpdateProduct using DB Adapter named 'Product Information'; this will invoke a stored procedure to insert and update database tables.
Currently, this is working for one row. However for multiple records, it is not working as intended. I reckon this is because of looping the calls and invokes.