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.
SELECT...FOR UPDATE will work on as many records as you want. I don't see the problem.
Click Here to Expand Forum to Full Width