delay
sleep for n seconds
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.
Examples
Simple example
create procedure
waitsome (in _interval integer)
{
delay (_interval);
}
SQL> waitsome (10);
Done. -- 10004 msec.