Re: SQL*FORMS 3.0 timer (sleep program)

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/09/10
Message-ID: <3416f855.3952787_at_www.sigov.si>#1/1

On Thu, 04 Sep 1997 22:09:05 -0400, 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.

You can call a procedure SLEEP from the package DBMS_LOCK. It takes a single IN parameter of the type NUMBER, which specifies the number of seconds to wait before returning the control to the calling session. The granularity of the time it handles is 1/100 of the second, e.g.

                DBMS_LOCK.SLEEP(5.55) will suspend the further execution for 5.55 seconds.

>Thanks.......Mashala

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Sep 10 1997 - 00:00:00 CEST