Re: command to wait

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 22 Sep 1999 22:13:02 GMT
Message-ID: <37ed53b3.9674542_at_news.siol.net>

On Wed, 22 Sep 1999 18:01:13 +0200, Stefan Leugers <Stefan.Leugers_at_t-online.de> wrote:

>Hey Freaks,
>
>I am searching for a command which just waits for a few seconds, and
>does not anything else. Help needed !
>
>StL.

DBMS_LOCK.SLEEP(<number_of_seconds>);

If sys.dbms_lock package is not created on your database, run dbmslock.sql and prvtlock.plb under user SYS.

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Sep 23 1999 - 00:13:02 CEST