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: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Wed, 16 Sep 1998 16:40:53 -0700
Message-ID: <Pine.OSF.3.95.980916163330.6526G-100000@gonzo.wolfenet.com>

This is the sleep command in pl/sql:

16:29:22 SQL> begin
16:29:28   2    dbms_lock.sleep(5);
16:29:33   3  end;
16:29:35   4  /

PL/SQL procedure successfully completed.

16:29:41 SQL>    --
Jeremiah Wilton http://www.wolfenet.com/~jeremiah   

On Wed, 16 Sep 1998, paul nguyen wrote:
>
> 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.
>
> 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.
> >
> > 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.
  

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Wed Sep 16 1998 - 18:40:53 CDT

Original text of this message

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