Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sleep-functionality within PL/SQL
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