Help on Locking [message #41376] |
Mon, 23 December 2002 23:50 |
Balamurugan.R
Messages: 91 Registered: March 2001
|
Member |
|
|
Hai,
I want to know, is it possible to lock procedure
or function when one person uses that procedure or
function, the other could not use it.
Thanks in advance.
With Regards,
Balamurugan.R
|
|
|
Re: Help on Locking [message #41377 is a reply to message #41376] |
Tue, 24 December 2002 00:11 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
You cannot lock a procedure/function from being executed (assuming the user has privileges to execute the code). However, you could have a control row in a table which you could lock coming in to the proc and unlock going out so that access was serialized (if row is already locked, exit the proc without running the main code).
|
|
|