Re: adding delay/pause/sleep inside oracle stored procedure

From: William Robertson <williamr2019_at_googlemail.com>
Date: 14 Jan 2007 02:03:26 -0800
Message-ID: <1168769006.907173.253600@s34g2000cwa.googlegroups.com>

Eric wrote:
> dbms_lock.sleep ?
>
> "jobs" <jobs_at_webdos.com> wrote in message
> news:1168285718.285298.23470_at_v33g2000cwv.googlegroups.com...
> > What's the best way to add a 500 second delay/pause/sleep inside an
> > oracle stored procedure?
> >

If accurate timing is important then the dbms_backup_restore version is preferable
(http://www.chrispoole.co.uk/tips/plsqltip1.htm) I must admit I'd forgotten about this until I saw Dan's reference to it. Received on Sun Jan 14 2007 - 04:03:26 CST