7.5 DBMS_LOCK

Table of Contents Previous Next


7 Built-In Packages : 7.5 DBMS_LOCK

SLEEP(seconds)
Advanced Server's implementation of DBMS_LOCK is a partial implementation when compared to Oracle's version. Only DBMS_LOCK.SLEEP is supported.
7.5.1 SLEEP
The SLEEP procedure suspends the current session for the specified number of seconds.
SLEEP(seconds NUMBER)
seconds specifies the number of seconds for which you wish to suspend the session. seconds can be a fractional value; for example, enter 1.75 to specify one and three-fourths of a second.

7 Built-In Packages : 7.5 DBMS_LOCK

Table of Contents Previous Next