SLEEP procedure - Suspends execution of current session for specified duration

The SLEEP procedure suspends the execution of the current session for the specified duration.

Syntax

Read syntax diagramSkip visual syntax diagram DBMS_LOCK.SLEEP ( seconds )

Parameters

seconds
An expression that returns a DECIMAL(9,3) value that specifies the number of seconds in which the session sleeps. Decimal values are rounded to the nearest integer. For example, if you specify the value 3.4, the session is suspended for 3 seconds.

Authorization

EXECUTE privilege on the DBMS_LOCK module.

Example

CALL dbms_lock.sleep(3)
Return Status = 0