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.