Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and Record Locking

RE: Oracle and Record Locking

From: <>
Date: Fri, 28 Jul 2000 14:30:06 EDT
Message-Id: <>

Actually, the default functionality in Forms 4.5 is to lock the row when someone changes a value in that row. If you query rows only, they are not locked. There is also an option to lock the rows only when committing, but I don't think many people use that option -- I know I haven't.

Marc Perkowitz
MTP Systems Consulting, Ltd.

In a message dated Thu, 27 Jul 2000 6:34:01 PM Eastern Daylight Time, Abdul Aleem <> writes:

<< Seth Dunehew

To my knowledge, FoxPro family of products also do that i.e., records fetched from the tables into a cursor have no relationship with the table. If same record is accessed by two different users, both have rights to update, the effective changes will be of the one who saves later.

In oracle, the moment a user initiates editing a record fetched into a form
(developer 2000), it is marked as locked (automatically -for third party
front-end / back-end this needs manual locking). The locks are automatically released, when the records are committed. I am talking about forms 4.5 and Oracle 8. Don't have any idea about earlier versions.

HTH! Aleem

 -----Original Message-----
Sent: 27 July 2000 20:18
To: Multiple recipients of list ORACLE-L Subject: Oracle and Record Locking

We have a consultant at our shop who is convinced that Oracle is inadequate for a serious multi-user environment because of the lack of record locking and dynamic result sets. We have been using it to develop and deploy a OLTP system and haven't found any serious problems that could not be addressed.

The dynamic result set that he has mentioned has me a little puzzled. He is stating that relational databases that he has worked with in the past returned a result set to him for use in his apps that would change dynamically if another user changed one of the records that he was displaying. I'm a relative newcomer to the database arena, 2 years, but this is something new. I've been told by another developer that Access will do this, but he hadn't heard of any serious systems that do.

Has anyone else heard of databases that perform that function?

Any suggestions on resources related to record locking in Oracle? We have two other developers that have worked with it extensively in the past, but the consultant is convinced that he knows differently, so we do need some solid research to refute him.


Seth Dunehew

Author: Seth Dunehew

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

Author: Abdul Aleem

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 28 2000 - 13:30:06 CDT

Original text of this message