Re: Sleep-functionality within PL/SQL

From: Peter Karl Lichtenwagner <peter_at_monochrom.at>
Date: Sat, 12 Sep 1998 13:50:16 +0200
Message-ID: <35fa5ff5.0@news.telekabel.at>

A call to dbms_pipe.receive_message listening on a private pipe wher eyou don't expect any messages and defining an appropriate timeout might solve your problem.

Regards,

Peter
peter_at_monochrom.at

Juergen Diet schrieb in Nachricht <35FA46E2.E1A32E93_at_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 - 06:50:16 CDT