Re: Sleep-functionality within PL/SQL

From: Alton Ayers <altona_at_ditw.com>
Date: Sat, 12 Sep 1998 09:28:27 -0400
Message-ID: <35FA76FB.A3D7E30B@ditw.com>

You can use DBMS_LOCK.SLEEP(time in seconds)

Juergen Diet wrote:

> How can I suspend the execution of a PL/SQL-program for a
> certain time? In SQL*Plus, I would issue the command "host sleep 60"
> to wait for one minute. Is there a similar possibility within PL/SQL?
> I know that in Oracle8 I can call external functions from PL/SQL
> and could write a little C-program that does the sleep, but I am still
> using Oracle V7.3.
> Any ideas?
> Regards,
> ------------------------------------------------------------
> Juergen Diet
> mailto:juergen.diet_at_mch.sbs.de
> ------------------------------------------------------------
>
Received on Sat Sep 12 1998 - 08:28:27 CDT