Is there a sleep type command for PL/SQL? I want to be able to pause my program for 5 minutes and then continue on. Any ideas?
Printable View
Is there a sleep type command for PL/SQL? I want to be able to pause my program for 5 minutes and then continue on. Any ideas?
DBMS_LOCK.SLEEP (seconds IN NUMBER);
http://download-east.oracle.com/otnd...l6a.htm#998467
It is good to be aware of some nasty bugs regarding DBMS_LOCK.SLEEP, particulary if you want to have relatively accurate sleeping intervals or if you want to sleep for a longer period of time (sey for more than half an hour). Those bugs are described at the "BUG Warning" of the following article:
http://www.jlcomp.demon.co.uk/faq/sleep.html
Those bugs were present in all release up to 8i (If I remember correctly I last checked and reported them to Oracle as bugs on 8.1.7, I haven't took my time to test if they have been resolved on 9i).
Thanks Jury a lot.
I didn't now about this problem.