DBMS_LOCK.SLEEP

DBMS_LOCK.SLEEP

"DBMS_LOCK.SLEEP" will be used if we want to create artificial slow down process between one function/procedure.

In below function we are providing "60" seconds delay between the process.

CREATE OR REPLACE FUNCTION FUNCTION_NAME(

    p_number IN NUMBER)

  RETURN BOOLEAN

AS

BEGIN

  DBMS_LOCK.sleep(60);

  RETURN TRUE;

END;