Pausing PL/SQL execution

[tonytrini]

Hi all,

How do I pause the execution of pl/sql code for, let's say one (1) second. I am unable to locate the appropriate syntax in help.

 

[stevecal]

Try this:

DBMS_LOCK.Sleep( seconds IN NUMBER);