Re: FOR UPDATE WAIT

sstetsen_at_gmail.com wrote:
>
> Hi! Can anybody explain why Oracle allows only INTEGERs for seconds in
> the clause FOR UPDATE WAIT <n>? Why I cannot use 0.5 sec or 1.1 secs?
> What would be the reason for such behavior and implementation? Thank
> you.

If you need more granularity, its easy to do yourself...

endless loop
  select for update nowait
  when ok then exit loop
  when error then dbms_lock.sleep(0.5)
end loop

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------