asked
How to restrict the stored procedure calling twice on submit ?
Hi, Is there any approach in stored procedure code level to restrict the procedure to call twice on SUBMIT button. waiting for your valuable inputs.
Prevention of user submitting twice should be handled at application level. This is the best way of doing it. I do not think handling it at database level would help your cause. You may end up with something undesired.
agree, the UI needs to handle this. the first step in the code needs to disable the button, then go on to make the request to the database. Logic in the database to recognise duplicate requests within NN (milli)seconds could also help but the UI needs to prevent the user causing the problem.
@Scot In that case It still smells like the web application OR application server being the culprit. Some serious Stress/Regression Testing with different option like very low network latency etc on application side needs to be done. Since I am sure there would be an/multiple application server/s being working as the middle-were, a check with NN milliseconds may still not be the best choice as it may cause some unwanted rollbacks.
@Usman I've seen this during my years as a web developer. It isn't always the user clicking twice, some other weirdness happens that calls the stored proc twice. It is usually less than 10ms apart--too quick for consecutive clicks. This was especially concerning for us during credit card processing apps.
You're saying that you want to execute the procedure two times? Then I would either execute it twice or just run the command within it two times.
Hey @satya, I just looked, after 18 questions you've never accepted an answer on any of them. If someone has helped you out, please mark the question answered by clicking on the check box under the appropriate answer. It's just below the little thumbs down symbol.
That's different than what you asked. In this case, any data submitted should have a unique constraint on the table to prevent duplicate data from being entered. That's all you have to do. Clicking submit any number of times will cause the insert to fail.
11 People are following this question.
