Re: switching locking off?

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/07/07
Message-ID: <132d6368.76d6a8b4@usw-ex0103-024.remarq.com>#1/1

You can not turn off Oracle row level locking, but you can do demonstrate what you want using the dbms_lock package. Create a document as a set of rows. You can have two sessions, same or different users, update different rows creating an inconsistent document. You can then demo the protection afforded by a user lock created and obtained by using dbms_lock.

DBMS_LOCK is documented in the Application Developers Guide.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Fri Jul 07 2000 - 00:00:00 CDT