RE: Using custom application locks

From: Amar Kumar Padhi <>
Date: Fri, 27 Mar 2009 21:53:19 +0400 (GST)
Message-ID: <5703177.28921238176626668.JavaMail.seven_at_aomfe2p1>

Hi Richard,
Yes I have used DBMS_LOCK in different scenarios and it does work perfectly fine. I started this thread because my statement that serialization could also be achieved otherwise with custom coding was debated in another posting. So I just wanted to prove with a sample code, using dbms_application_info in specific.

This thread is just for the sake of debating custom locks in particular and not intended to challenge dbms_lock usage.


-original message-

 RE: Using custom application locks
From: "Goulet, Richard" <> Date: 27-03-2009 19:47


    There is a much simpler way that Oracle has provided for some time ....

-- Received on Fri Mar 27 2009 - 12:53:19 CDT

Original text of this message