Use PL/SQL packages

You should use PL/SQL packages to store application logic and large PL/SQL code. PL/SQL packages provide an effective way to group similar functionality. Using stored procedures and functions, instead of inline PL/SQL code, is not only faster since the packaged code is already compiled but it also helps to make the application easier to maintain by avoiding duplicate code in multiple spots. It also makes it easier to debug and test the PL/SQL code by using external tools like the Oracle SQL Developer, which has some specific built-in APEX integration, and it's distributed free of charge.

PL/SQL packaged code can be accessed from any relevant APEX component, e.g. Computations, Validations, and application/page level Processes, and as such can be shared (re-used) across a specific application or across multi APEX applications.

Protect your business logic secrets

Using PL/SQL packages for the application logic has another very important advantage. While the APEX in-line...