Re: where to place the dbms_alert.waitone in forms?
From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Tue, 16 Mar 1999 11:08:51 +0800
Message-ID: <36EDCB43.D833220_at_ccis.adisys.com.au>
Date: Tue, 16 Mar 1999 11:08:51 +0800
Message-ID: <36EDCB43.D833220_at_ccis.adisys.com.au>
Brandon Lee wrote:
> hi anyone,
> if i am not wrong, the dbms_alert.waitone or waitany will wait for signal
> for 1 or more seconds depending on the timeout seconds specified. if I use
> this function in forms application, where should i place it in order not to
> obstruct the execution path? What i wanted is to be able to constantly wait
> for signal while others part run normally. Is there an example somewhere i
> can look at?
One way to do this is to put the dbms_alert.waitone in a when-timer-expired trigger. Define a repeating timer and each time it expires the trigger will check for an alert.
HTH Geoff Received on Tue Mar 16 1999 - 04:08:51 CET