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: Dave Wotton <Dave.Wotton_at_no-spam.it.camcnty.gov.uk>
Date: 12 Sep 1998 18:07:35 GMT
Message-ID: <6ted97$ma$1@dns.camcnty.gov.uk>


> From: Juergen Diet <juergen.diet_at_mch.sbs.de>
> Date: Sat, 12 Sep 1998 12:03:14 +0200
>
>How can I suspend the execution of a PL/SQL-program for a
>certain time?

dbms_lock.sleep(n)

where n is sleep duration in seconds.

Dave.
--
Remove the no-spam bit from my email address to reply. Received on Sat Sep 12 1998 - 13:07:35 CDT

Original text of this message

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