Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FOR UPDATE WAIT

Re: FOR UPDATE WAIT

From: Connor McDonald <connor_mcdon..._at_yahoo.com>
Date: Thu, 10 Nov 2005 23:30:13 +0800
Message-ID: <43736785.102A@yahoo.com>


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."

------------------------------------------------------------
Received on Thu Nov 10 2005 - 09:30:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US