Updating multiple rows oracle
Result: The interface is getting pass but failed to update the database, though the generated request payload is correct. This exception is considered not retriable, likely due to a modelling mistake.
Need to see the configuration of adapter to figure this out.
#3 - This again depends on the query and the loop used which can be determined by looking at the flow. You need to utilize the For-Each Loop activity in orchestration level - but this will result to 1:1 activity ratio, like 1 insert/update activity means 1 DB call.