CODEWITHSUNDEEP
oracle-databaseplsqloracle-apex
Tayeb HAMDAOUI
Tayeb HAMDAOUI

Reputation: 63

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 ?

Upvotes: 0

Views: 427

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

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.

Upvotes: 0

Related Questions