Use dbms_session.sleep for Oracle Database 18c or higher
Use dbms_session.sleep for Oracle Database 18c or higher

dbms_lock.sleep is also supported which requires explicit
grant statement executed like 'grant execute on sys.dbms_lock to hr'.

dbms_session.sleep can be executed without additional grant statement,
which is convenient for CI environments.

Refer
https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SESSION.html#GUID-27CCC2F7-6564-41D2-8C42-CFFBF25A69B5
https://oracle-base.com/articles/18c/dbms_session-sleep-18c

rsim/ruby-plsql,yahonda/ruby-plsql,rsim/ruby-plsql,yahonda/ruby-plsql