Have a look at DBMS_LOCK.SLEEP.


-----Original Message-----
Sent: Thursday, 31 August 2000 0:25


In more than one PL/SQL script we've written we have the need to pause
execution for a few seconds.  Currently we're using a tight loop to hold up
the script, but that maxes out the processor on our NT server.  Is there a
better way to delay a PL/SQL script?