skipping locked rows

I've searched for an answer and unable to come up with one. We have a need to have multiple people update rows in a single table. It is desired that the application get the first unlocked row that needs updating, make changes with user input, update and commit. Then get next row. Same app will be used by at least two people simultaneously. Querying the db after each update will not be a performance problem for us in this application.

In SQL Plus I've tried
select col1, col2, col3
from table1
where rownum = 1
for update nowait skip locked

The first query brings back the result set, the second brings back no rows.

We're using Oracle 8i, Delphi, Direct Oracle Access Components

Any suggestions?

Thanks in advance,
Kent Brye
kbrye_at_ncbex.org Received on Tue Mar 05 2002 - 11:04:49 CST