---
title: "Scott Wesley (@swesley-perth) | Hashnode"
description: "Oracle APEX Consultant. Read the latest articles by Scott Wesley on Hashnode."
url: "https://hashnode.com/@swesley-perth"
---

@swesley-perth

# Scott Wesley

@swesley-perth · Joined November 2025

Oracle APEX Consultant

## Comments

[I think the list of reasons why can be extended in the context of an APEX environment. a) Compiling code in packages improves performance by lessening the amount of interpreted code that needs to be parsed at runtime. This can be significant, and is the reason it's encouraged to move plugin PL/SQL to a package instead of retaining the inline PL/SQL b) Any missing privileges you may have in your deployment are more likely to be found at compile time, not runtime. c) Testing - not mentioned in the linked post, but a suitably de-coupled procedure can be unit tested outside the scope of APEX.](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61/comment/691145d78fb801359e752dcd)

Comment · Article · Nov 10, 2025 · [Call PL/SQL APIs Declaratively from APEX Using the Invoke API Process](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61)
