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 later
Oracle 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.
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 ;
DBMS_OUTPUT.PUT_LINE('Start ' || to_char(SYSTIMESTAMP, 'HH24:MI:SS'));
DBMS_OUTPUT.PUT_LINE('End ' || to_char(SYSTIMESTAMP, 'HH24:MI:SS'));
The output is for the example is:
It should be :
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.
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