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

jobs wrote:
> What's the best way to add a 500 second delay/pause/sleep inside an
> oracle stored procedure?
>

BEGIN

   dbms_backup_restore.sleep(100);
   dbms_drs.sleep(150);
   dbms_lock.sleep(250);

But yeah ... why?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org