BICS\APEX SLEEP

Tcarvalho

Summary

BICS\APEX SLEEP

Content

Hi All,

As part of a piece of script, waiting for the generation of a report in a 3rd party app, I need to make my code wait for a couple of seconds.

I've tried APEX_UTIL.PAUSE, which is not documented in APEX 5.1. However the following code does not fail but also doesn't do anything.

BEGIN

    DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));

    APEX_UTIL.PAUSE(2);

    DBMS_OUTPUT.PUT_LINE('End   ' || to_char(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'));

END;

I've tried DBMS_LOCK.SLEEP, but since this is a Cloud instance I was not really expecting it to work.

Any idea if there's any out of the box Wait\Pause\Sleep function?

I was trying to avoid using a very big for loop for the wait.

Thanks for the Support,

Tiago