Locking management in Stored Procedures

Sep 17, 2007 at 3:44 PM
I saw the following comment in the RetrieveNonblockingInstanceIds stored procedure:

------------------------------------------------------------------------------------------------------
-- REVIEW
-- SQL Server implementation uses TABLOCK,UPDLOCK,HOLDLOCK
-- do we need this here... (think not, Oracle handles
-- this better than SQL Server..?)
------------------------------------------------------------------------------------------------------

But I think actually we need to control the locking in the table. Why don't we use the "Select ... for update" command in Oracle?
Coordinator
Sep 18, 2007 at 12:11 AM
Hi there,

Yup I think you're right. I'll check this in for both Oracle and MySql later this week once I've done some testing.

Cheers,

Dean