DBMS_LOCK v15
EDB Postgres Advanced Server provides support for the DBMS_LOCK.SLEEP procedure.
| Function/procedure | Return type | Description |
|---|---|---|
SLEEP(seconds) | n/a | Suspends a session for the specified number of seconds. |
EDB Postgres Advanced Server's implementation of DBMS_LOCK is a partial implementation when compared to Oracle's version. Only DBMS_LOCK.SLEEP is supported.
SLEEP
The SLEEP procedure suspends the current session for the specified number of seconds.
SLEEP(<seconds> NUMBER)
Parameters
seconds
seconds specifies the number of seconds for which you want to suspend the session. seconds can be a fractional value. For example, enter 1.75 to specify one and three-fourths of a second.
- On this page
- SLEEP