Record Locking Using For Update In Oracle

[Ira]

Hello All,

When we select a record using for update in the SQL to force a record lock
by the select statement. If this record is already locked by another user
then the system will hang until the other user rollbacks or commits.

Is there a way to have oracle return an error code when the record is
already locked by another user. If so how?

Thank You In Advance For Your Time And Effort.

Ira