Execution Chains Page Processing new Feature 23.1

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Execution Chains Page Processing new Feature 23.1

Post by admin »

Page Processing Improvements
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
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests