Re: Sleep in PL/SQL?

In article <31485a70.3698155_at_nntp.ix.netcom.com>, chuckh_at_ix.netcom.com (Chuck Hamilton) writes:
|> Is there any way to tell PL/SQL to sleep for X seconds before
|> proceeding to the next line of code?
|> --
|> Chuck Hamilton
|> chuckh_at_ix.netcom.com
|>
|> If at first you don't succeed, skydiving isn't for you.
Yep. Use the DBMS_LOCK.SLEEP procedure. It takes the number of seconds as an argument. I believe that you can even specify fractions of a second.

-- 
Scott Urman
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"