Sleep-functionality within PL/SQL

From: Juergen Diet <juergen.diet_at_mch.sbs.de>
Date: Sat, 12 Sep 1998 12:03:14 +0200
Message-ID: <35FA46E2.E1A32E93@mch.sbs.de>

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 - 05:03:14 CDT