Re: TIMER (having resolution in seconds)

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 08 Sep 1999 18:32:29 +0800
Message-ID: <37D63B3D.6E3F@yahoo.com>

shuchi5845_at_my-deja.com wrote:
>
> I need to code a timer which can return TRUE
> or false depending upon the fact if
> certain INPUT-ABLE (parameter) number of seconds
> have elapsed.
> According to the instructions to me
> I cannot use DBMS_ALERT or SLEEP
> packages. Also I should not use anything that uses
> SYSDATE too frequently (like every instruction
> cycle).
>
> Can anybody help?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

check dbms_utlity.check_time

it may be what you are after...

or alternatively, raise a lock with dbms_lock in a separate session and then try to get it your current session with the timeout that you want (this is a blocking wait)

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Sep 08 1999 - 05:32:29 CDT