My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.