Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to set a timer in PL/SQL
Jpmill wrote:
> that's ok I found it !
>
> It's beacause someone said to me that I could code a timer with
> DBMS_ALERT.WAITONE('TIMER', alert_msg, alert_status, 5)
>
> it does a 5 second timer.
Take a look at DBMS_LOCK.SLEEP too.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Mar 27 2006 - 13:42:11 CST