'How to create shared component / application processes from a PL/SQL script in APEX?

I was following this documentation about apex 21.2 API, and I don't know how to create an application process that is located in the shared component of an APEX application using APEX API.

Essentially I want to create a PL/SQL process that is called after each page submit but create it from sqlplus.

Is there a PL/SQL package that can do this, or the only way is using the UI ?



Solution 1:[1]

You can create an Application Process (under Shared Components), with the Point set to On Submit: After Page Submission - After Computations and Validations.

The code for the process can call, for example, a procedure in a package you have created.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Jeffrey Kemp