Locking multiple records in PL/SQL

[Bala]

Hi All

Is it possible to lock multiple records in PL/SQL ?

1) I cannot use "select ... for update" since the numbers of rows returned is not one and also it will vary.
2) I cannot use "cursors ... for update" bcoz, I need to just lock a bunch of records so that no one touches it.
3) I do not want to use lock table..., as this will not allow others to insert or update the records.

Is there any way one can lock multiple records in PL/SQL and release these locks once my processing is complete ?

Any help will be greatly appreciated.

Thanks
Bala

[chrisrlong]

SELECT...FOR UPDATE will work on as many records as you want. I don't see the problem.

- Chris