Re: UTL_FILE and locking

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 16 Nov 2006 04:55:34 -0800
Message-ID: <1163681733.965385.25590@f16g2000cwb.googlegroups.com>

Mladen Gogala wrote:
> 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".

Is this adding value to the posting?

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.

Does that mean you advocate on windows and VMS that multiple oracle processes should attempt to write to the same file simultaneously via UTL_FILE? Are you attempting to indicate that you believe that on those platforms UTL_FILE is aware of ( apparently ) os level locking?

> This, of course, doesn't have anything to do with your advice to use
> DBMS_LOCK, which I can only second.

Not sure exactly what you are trying to get at with this posting. Received on Thu Nov 16 2006 - 06:55:34 CST