Hi all, for clearing this out, I will prepare a sample program using my logic by today evening (it is 1800 now) and post it here for you guys to test and confirm. I will avoid using this thread and create a new one with subject "Using custom application locks". FmHabash you can continue to use lock as you have decided, do have a look at my posting later just to get a broader perspective. Thanks! amar Www.amar-Padhi.com -original message- Subject: Re: Grabbing sequence values blocks in consecutive order: Need a guaranteed method. From: "Alex Fatkulin" <afatkulin@xxxxxxxxx> Date: 26-03-2009 00:17 Amar, the method you described in your article can not be used for what you say it can be used. It has nothing to do with thinking differently. Look at the example which I gave -- your code isn't safe during race conditions. On Wed, Mar 25, 2009 at 3:44 PM, Amar Kumar Padhi <amar.padhi@xxxxxxxxx> wrote: > Well not at all alex, I just like to think differently. -- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- //www.freelists.org/webpage/oracle-l