Stored Procedure Concurrent Updates
Hi,
I have a stored procedure written in MySQL which reads and updates a status in a table.
The Problem is when more than one user is calling the stored procedure that is from multiple machines(say 5 machines) concurrently, all the machines are reading the same status at a time. So here i want to restrict each machine reading once rather than all the machines reading at sametime. So does stored procedure puts a lock on the concurrent reads, if not how to achieve that.
Please help.
regards,
Ranjan
Subject
Views
Written By
Posted
Stored Procedure Concurrent Updates
1665
May 22, 2018 12:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.