Name
delay — sleep for n seconds
Synopsis
delay
( |
in n_seconds integer
) ; |
Description
This will halt calling procedure execution for specified interval in seconds.
Parameters
n_seconds
INTEGER number of seconds to sleep.
Return Types
None
Examples
Example24.89.Simple example
create procedure waitsome (in _interval integer) { delay (_interval); } SQL> waitsome (10); Done. -- 10004 msec.