I have a .NET application that I want to use row level locking in Oracle. There are about 300 users that can simultaneously access the application that I have built. If each person tries to access a given issue number I want them to be denied access with raise_application_error("issue already being modified").
How do I create this?
The transaction would have to be inside of .NET I am guessing? If it is in .NET how can I SELECT FOR UPDATE when the update is taking place in a separate method?
Any thoughts would be great.
Trial and error would be horrific in terms of time taken to build a prototype.
Please give me your thoughts.