Oracle V7.3.2 question

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. Received on Mon Nov 04 1996 - 00:00:00 CET