Re: Sleep function in PL/SQL

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1996/11/11
Message-ID: <568d2n$gkv_at_inet-nntp-gw-1.us.oracle.com>#1/1


In article <32877cbf.43317040_at_news.lejonet.se>, maro_at_gbg.ifsab.se (Magnus Rosenquist) writes:
|> Hi !
|>
|> I was just wondering if there exist a function similar to the unix
|> shellscript command 'sleep(10)' in PL/SQL, where '10' would be the
|> number of seconds the process should wait before proceeding.

DBMS_LOCK.SLEEP takes a number of seconds to sleep. You can specify up to a resolution of a hundredth of a second.

|>
|> If anyone knows of an existing function, I would be thankful for a
|> tip. Otherwise I will probably write one myself, and post it here.
|>
|> Thanks for your time !
|>
|> /Magnus
|>
|>
|>
|> \ Magnus Rosenquist \
|> \ IFS Sweden AB \
|> \ maro_at_gbg.ifsab.se \



Scott Urman Oracle Corporation surman_at_us.oracle.com

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"
Received on Mon Nov 11 1996 - 00:00:00 CET

Original text of this message