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

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Wed, 1 May 2002 22:36:36 +0200
Message-ID: <aapjjc$8d8$1@news1.xs4all.nl>

Use:

dbms_lock.sleep(60);

For more info see your documentation CD (or visit doc.oracle.com), In Oracle 8.1.7 the book is titled "Oracle8i Supplied PL/SQL Packages Reference, Release 2 (8.1.6)", part no A76936-1. See Chapter 19 "DBMS_LOCK".

Fan Ruo Xin <fanruox_at_sbcglobal.net> schreef in berichtnieuws 3CD04D0C.896C4800_at_sbcglobal.net...
> 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
>
Received on Wed May 01 2002 - 15:36:36 CDT