Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sleep-functionality within PL/SQL

Re: Sleep-functionality within PL/SQL

From: paul nguyen <pfaipp_at_ix.netcom.com>
Date: Wed, 16 Sep 1998 16:12:53 -0500
Message-ID: <360029D5.CCD04433@ix.netcom.com>


Hi Peter,

Correct me if I am wrong, I thought that dbms_pipe package will create a process that takes a while to die out in the host system. By issueing dbms_pipe.receive_message, a process is created and stay alive even after timeout reaches..(???)

Regards,

Paul

Peter Karl Lichtenwagner wrote:

> 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 Wed Sep 16 1998 - 16:12:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US