Re: Sleep in PL/SQL?

From: Gerard H. Pille <ghp_at_infosoft.be>
Date: 1996/03/14
Message-ID: <4ia61u$1vu_at_news.Belgium.EU.net>#1/1


In article <31485a70.3698155_at_nntp.ix.netcom.com>, Chuck Hamilton (chuckh_at_ix.netcom.com) says...
>
>Is there any way to tell PL/SQL to sleep for X seconds before
>proceeding to the next line of code?
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>
>If at first you don't succeed, skydiving isn't for you.

I vaguely remember something about timers ...

HEY! WAKE UP! Oracle 7 Server Application Developers Guide, pag. A-14

dbms_lock.sleep(seconds)

I like that book very much, one keeps learning new things. Why do you need it, does your program run too fast?

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard
Received on Thu Mar 14 1996 - 00:00:00 CET

Original text of this message