APEX_UTIL.PAUSE Not Working in Schema Service and Exadata Express
(Doc ID 2455951.1)
Last updated on FEBRUARY 24, 2019
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database Cloud Schema Service - Version N/A to N/A [Release 1.0]
Oracle Application Express (APEX) - Version 5.1.4 and later
Information in this document applies to any platform.
Symptoms
When trying to pause the execution of package and so that an activity can complete and resume the execution again, using APEX_UTIL.PAUSE function doesn't work.
It should pause as per the function.
Steps to reproduce:
-------------------------------
1. Go to SQL Workshop > Commands
2. Execute :
SET SERVEROUTPUT ON ;
BEGIN
DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSTIMESTAMP, 'HH24:MI:SS'));
APEX_UTIL.PAUSE(5);
DBMS_OUTPUT.PUT_LINE('End ' || to_char(SYSTIMESTAMP, 'HH24:MI:SS'));
END;
/
The output is for the example is:
Start 16:22:26
End 16:22:26
Statement processed.
0.00 seconds
It should be :
Start 16:22:26
End 16:22:31
Statement processed.
0.05 seconds
In apex.oracle.com and customer-managed cloud services, such as Database Cloud Service (DBCS / DBaaS) - OCI Classic (OCI-C) and Database Cloud Service OCI , the command works as expected.
Only in Schema Service it doesn't work.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |