Re: Oracle V7.3.2 question

If you use Oracle Developer 2000, all these will be handled by the package and you don't have to worry about multiple user environment. Otherwise consider using SELECT ... FOR UPDATE NOWAIT to lock row/rows. The nowait statement will return a resource busy exception and you can handle it in your application.

Keshav Deshpande (deshkesh_at_msn.com) wrote:
: To all the Oracle Gurus out there:
 

: I am developing a client-server application (front end: Delphi 2.0
: and backend: Oracle 7.3.2).
 

: The users can view records in data-bound grids. The problem is that
: multiple users could be accessing the same set of tables on Oracle at
: the same time.
 

: Here is my question:
 

: When I do a simple "select" query on the database, is there any way I
: can find out whether a particular record in a table has been
: currently locked by a user (i.e. this user has an exclusive
: read/write lock on this record while all the other users can only
: browse this particular record). When I retrieve the result-set from
: the query, I want to provide a visual clue of this to the user by
: painting a 'locked' icon in the left-most column of the grid for that
: particular record.
 

: Also, I want to be able to notify all users who will have read access
: only if or when they try to modify the record.

: Any help would be greatly appreciated.
 

: Thanx,
: Keshav.

--
****************************************************************************
Peter Tik-Meng Lim      ,  mte_at_moe.edu.sg                      
Senior Software Engineer,  National Computer System Ltd
****************************************************************************