Re: command for sleep in Oracle

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 22 Sep 1999 22:12:19 GMT
Message-ID: <37eb51b3.9162242@news.siol.net>

On Wed, 22 Sep 1999 20:11:20 GMT, sudheenair_at_my-deja.com wrote:

>I need an equvlent command in oracle similar to the "waitfor delay
>hh:mi:ss" in sybase.
>
>This is required me to spawn a process every 15 seconds. Can any of you
>help me ?

DBMS_LOCK.SLEEP(15); 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 Wed Sep 22 1999 - 17:12:19 CDT