Re: SQL*FORMS 3.0 timer (sleep program)
Date: 1997/09/05
Message-ID: <5up6a3$c7t_at_info.csufresno.edu>#1/1
In article <340F69C1.2F31_at_us.net>,
Mashaallah Ebrahimian <mebrahim_at_us.net> wrote:
>Does anyone know how to make a SQL*Forms 3.0 (on SUN, SGI, VAX
>platforms) application to wait or go to sleep for a specific amount of
>time before requerying a table for data? I have thought of DBMS_ALERT
>but it signals all the sessions upon triggering of an event.
>
>If you know of a clever way to do this, I appreciate an email to
>mebrahim_at_us.net.
>
>Thanks.......Mashala
Create or replace
PROCEDURE Wait_a_sec(SECONDS IN NUMBER DEFAULT 1) IS
-- Calling this procedure will cause any process to wait or sleep
-- for the number of seconds specified.
NUM NUMBER;
BEGIN
NUM := DBMS_PIPE.RECEIVE_MESSAGE('ZZZSLEEPZZZ',SECONDS);
END;
You may have to grant execute on dbms_pipe to the procedure owner.
HTH
Steve Cosner
Received on Fri Sep 05 1997 - 00:00:00 CEST