How to Sleep (wait) in PL/SQL

When you writing code in PL/SQL , you some times need to have logics for the application to sleep before the next processing. In PL/SQL you can use the below syntax for this Syntax dbms_lock.sleep(no_of_seconds); Conditions User should be granted with execute priviledge to dbms_lock package directly by SYS (Not via role) grant execute on dbms_lock to user;