Group a sequence of page processes to offload processing to the background or just simplify maintainability of conditional execution.
Control Background Execution
More control over processes executing in the background with the addition of monitoring to the Active Sessions page. Report on running background executions when a page or app is deleted, and allow developers to continue to abort them.
Execution Chains
Introducing a new Page Process Type, Execution Chains. Executing page processes one after another by adding them as children of a chain, and declaratively run chains in the background or foreground.
Status and Progress Reporting
Package = APEX_BACKGROUND_PROCESS
VIEW = APEX_APPL_PAGE_BG_PROC_STATUS
Code: Select all
create table my_demo (name varchar2(20) primary key, value number);
create or replace FUNCTION delay(seconds IN NUMBER) RETURN NUMBER IS
BEGIN
IF seconds > 0 THEN
DBMS_SESSION.SLEEP(1);
RETURN delay(seconds - 1);
ELSE
RETURN 0;
END IF;
END;
select * from APEX_APPL_PAGE_BG_PROC_STATUS where execution_id = 1521659680