POLARDB compatible with Oracle supports the DBMS_LOCK.SLEEP stored procedure.

Table 1. DBMS_LOCK stored procedures
Function/stored procedure Return type Description
SLEEP(seconds) N/A Pauses a session for the specified number of seconds.

The DBMS_LOCK package in POLARDB compatible with Oracle is only partially implemented when compared to Oracle's version. POLARDB compatible with Oracle only supports DBMS_LOCK.SLEEP.

SLEEP

The SLEEP stored procedure is used to pause the current session for the specified number of seconds.

SLEEP(seconds NUMBER)

Parameters

Parameter Description
seconds Specifies the number of seconds for which the session is to be paused. You can specify a fractional value. For example, you can specify 1.75 to indicate one and three-fourths of a second.