Message-Id: <10571.113165@fatcity.com> From: "Elliott, Patrick" Date: Thu, 27 Jul 2000 15:17:34 -0500 Subject: RE: Oracle and Record Locking Wayne and William are right. The problems that your consultant refers to are simply a matter of application coding practices. If you want your application to prevent changes of a row while you are viewing it, then you need to issue an explicit lock on the record using the "FOR UPDATE OF " in the select statement. If you want to allow changes to a row while you are viewing it, then you need to periodically refresh the screen. I wouldn't advise this, however since you have no way of maintaining integrity. I found this in the Oracle documentation. > -----Original Message----- > From: William Beilstein [SMTP:BeilstWH@obg.com] > Sent: Thursday, July 27, 2000 1:46 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle and Record Locking > > Tell your consultant that if he doesn't know that oracle and all real > databases uses record locking that he probably should not be doing any > work on real databases and should go back to his Access or DBASE files. > > >>> "Wayne M Johnston" 07/27/00 12:44PM >>> > Seth, > > Oracle and many other databases use record locking to maintain data > integrity. > That is why they are 'serious systems' and access is not. > > Just my opinion, > > Wayne Johnston > DBA > > > > > > Please respond to ORACLE-L@fatcity.com > > > To: Multiple recipients of list ORACLE-L > cc: (bcc: Wayne M Johnston/BCBSO/TBG) > > > > > > > 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. > > Thanks > > Seth Dunehew > -- > Author: Seth Dunehew > INET: sdunehew@medicalmatrix.com > > 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: ListGuru@fatcity.com (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). > > > > > > > -- > Author: Wayne M Johnston > INET: wmjohns@regence.com > > 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: ListGuru@fatcity.com (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). > > -- > Author: William Beilstein > INET: BeilstWH@obg.com > > 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: ListGuru@fatcity.com (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