Oracle DBA to rewrite SP handle Upsert batches

In Progress Posted 4 years ago Paid on delivery
In Progress Paid on delivery

We have a Stored Procedure today that upserts row by row from a Logic App. Its very inefficient since if its 50.000 rows it does 50.000 requests to the DB.

Instead we would like to be able to send the whole batch to the Stored Procedure and let it insert these in a more efficient way.

Oracle Database Administration Database Development

Project ID: #21355975

About the project

1 proposal Remote project Active 4 years ago

Awarded to:

pterik

Hi. My name Vitaly, I'm a developer from Ukraine. I work as an outsource database developer last 5 years, and you may look at my profile on [login to view URL] (/in/makhaev) Also, I worked as Oracle DBA for Miratex company More

$90 USD in 4 days
(0 Reviews)
0.0