I have a procedure running which is locking a table. I want to execute another one, knowing fullwell it wants to use the locked table. Can I go home and expect the 2nd proc. to run when the table becomes unlocked or will it time out while waiting and send an error.
-KThe procedure will wait indefinitely unless there is a deadlock or the LOCK_TIMEOUT setting has a value other than -1.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment