Discussion on "APEX Background Page Processing - The Definitive Guide"

Jon Dixon · 2024-09-19T12:48:10.944Z

Introduction Most enterprise applications have workloads that need to be run in the background. This is often a more efficient use of system resources and also allows users to continue working with your App while the processing takes place. APEX prov...

As usual a great article John. What are your thoughts about using this mechanism in a SaaS application where you have several tenants, each one with many users, so a given process in the application could be run "at the same time" simultaneously by lots of different users. I'm worried about hitting the Maximum number of background page processes easily. The app runs on an ADB in the OCI APEX.

Thanks in advance

Regards

Thanks Jon

Another great quick overview and summary

Oh boy! Am I glad that you didn't retire? Thank you for this great post.

Thank you, much appreciated.

Very well done, and helpful.
I have an IG using FOS plugin to add Menu Items to "Actions Menu" that trigger a custom event that causes a Dynamic Action to fire executing PL/SQL code using Primary Keys of currently selected IG rows and other page item values. I want to move the PL/SQL code to a background process and cause it to fire as one of the actions of the Dynamic Action. Ideas on how to do that? In short, how to fire a background Process from a Dynamic action that uses Page Item values? It seems it has to be a button click event? Or a submit, but then I lose which items were selected? Thoughts? Thanks Joe

Jon Dixon Hi Jon, Thanks for the quick and helpful options. I am thinking a good APEX Idea could be making it possible to fire a process with a custom event similar to DAs? Joe

Jon Dixon Hi Jon, FYI I went the dbms_scheduler route, but setting argument values for a PLSQL_BLOCK generates an error saying that type does not allow arguments. I handled it by pre-constructing the job_action to build the parameter values into the job_Action parameter value. Thanks again, Joe

Joe Kerr makes sense.

Discussion

APEX Background Page Processing - The Definitive Guide

Responses(4)

Recent in Forum

Search Hashnode

APEX Background Page Processing - The Definitive Guide

Responses(4)

Recent in Forum