How to ensure only one process accesses a record in Oracle database table

We have multiple processes running in parallel accessing the same database table in Oracle. The processes access the table thru a trigger and a stored procedure written for the trigger.

We want only one process to pick a record and update it with a status.

Is it possible to lock a record in Oracle ? Can any one tell me how we can achieve this?

Thanks,
Srini Received on Tue Oct 12 2004 - 02:27:46 CDT