Re: UTL_FILE and locking

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Thu, 16 Nov 2006 05:34:00 GMT
Message-Id: <pan.2006.11.16.05.34.00.493049@verizon.net>

On Wed, 15 Nov 2006 07:45:26 -0800, hpuxrac wrote:

> You use DBMS_LOCK to implement custom locking. UTL_FILE won't know
> anything about locks.

The correct sentence would be:"ON UNIX, UTL_FILE won't know anything about the locks". On Windows 2000 and VMS, record level locking is automatic, you can't turn it off. Two processes can not write to the same record at the same time.
This, of course, doesn't have anything to do with your advice to use DBMS_LOCK, which I can only second.

-- 
http://www.mladen-gogala.com

Received on Wed Nov 15 2006 - 23:34:00 CST