Re: 'sleep n' in PL/SQL block?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 01 May 2002 21:26:38 +0100
Message-ID: <3CD04F7E.2007@yahoo.com>

Fan Ruo Xin wrote:
>
> Hi,
> Suppose I need to write a PL/SQL block as:
> (psedo code)
> DECLARE
> ...
> BEGIN
> ...
> sleep 60
> ...
> END
>
> How can I implement the "sleep 60" in PL/SQL block? Is there any way to
> do this?
> Thanks,
> Rosaline

dbms_lock.sleep(n)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Wed May 01 2002 - 15:26:38 CDT