Re: Commit without freeing locks
From: MNAHanda <mnahanda_at_aol.com>
Date: 1996/10/12
Message-ID: <53pojb$22f_at_newsbf02.news.aol.com>#1/1
Date: 1996/10/12
Message-ID: <53pojb$22f_at_newsbf02.news.aol.com>#1/1
Hi!
Yes, I have personally used this concept to solve exactly the problem
you are facing. The only thing you need to keep in mind though is that
the DBMS_LOCK package creates user level locks. These are not REAL
locks. As long as you are controlling the mechanism through your
applications
everything should be fine. However, if somebody tries to access the table
that
was locked by your application, via say, SQL*Plus, the lock will not be
visible
to this person, and he will have the capablility to go ahead and modify
your
locked records!! So, be careful out there!
Have fun,
Manisha Handa
Manisha Handa
Received on Sat Oct 12 1996 - 00:00:00 CEST