Search notes:

Oracle PL/SQL: Wait (sleep) for the given amount of time with DBMS_LOCK.SLEEP

Executing dbms_lock.sleep(secs) makes the session wait for secs seconds.
begin
   dbms_output.put_line(to_char(sysdate, 'hh24:mi:ss') || ': going to sleep for 3 seconds.');
   dbms_lock.sleep(3);

   dbms_output.put_line(to_char(sysdate, 'hh24:mi:ss') || ': going to sleep for 5 seconds.');
   dbms_lock.sleep(5);

   dbms_output.put_line(to_char(sysdate, 'hh24:mi:ss') || ': finished.');
end;
/
Github repository oracle-patterns, path: /Installed/dbms/lock/sleep.sql

See also

dbms_lock.sleep is deprecated in favor of dbms_session.sleep (see also PLS-00201: identifier 'DBMS_LOCK' must be declared)
dbms_lock
The SQL Server equivalent of dbms_lock.sleep is roughly waitfor delay.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1738293892, '3.135.241.251', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/lock/sleep(56): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78