busy_resource EXCEPTION;There will be one problem with multi row update...but many of us are avoiding MRU,MRD because of problems that on heavy multi user environment this operation may fail more then is acceptable...of course with not accepting error on error page.
PRAGMA EXCEPTION_INIT(busy_resource, -00054);
-- try to lock that row
select * from table where id=xxx for update nowait (wait xxx);
--do that ML row processing!
when busy_resource then
-- no exception is made...just some message...