---
title: "Discussion on \"Call PL/SQL APIs Declaratively from APEX Using the Invoke API Process\" | Hashnode"
description: "Discussion on \"Call PL/SQL APIs Declaratively from APEX Using the Invoke API Process\". Learn how to call PL/SQL APIs declaratively in Oracle APEX using the Invoke API Process"
url: "https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Call PL/SQL APIs Declaratively from APEX Using the Invoke API Process](https://blog.cloudnueva.com/apex-invoke-api-processes?utm_source=hashnode&utm_medium=feed)

Learn how to call PL/SQL APIs declaratively in Oracle APEX using the Invoke API Process

May 11, 2023 · 5 min read · blog.cloudnueva.com  
Read the article

-   [#oracle](https://hashnode.com/tag/oracle)
-   [#orclapex](https://hashnode.com/tag/orclapex)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 3

Markdown supported · ⌘↵ to post

[Scott Wesley](https://hashnode.com/@swesley-perth)

[Nov 10, 2025](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61/comment/691145d78fb801359e752dcd)

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.

[Sjahrial Sjafri](https://hashnode.com/@riesjahrial)

[Dec 6, 2023](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61/comment/6570a0b837f7fa8c152ab308)

very,very helpful

[Jon Dixon](https://hashnode.com/@orclapex)

[Dec 6, 2023](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61/comment/6570a0b837f7fa8c152ab308#reply-6570f2b737f7fa8c152cc5e7)

Thank you for the feedback.

[Igor Parmezani](https://hashnode.com/@IgorParmezani)

[May 11, 2023](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61/comment/645cece4aa9a486af6d62c0e)

Great stuff!

[Jon Dixon](https://hashnode.com/@orclapex)

[May 12, 2023](https://hashnode.com/posts/apex-invoke-api-processes/645ce4ce323801e31e178e61/comment/645cece4aa9a486af6d62c0e#reply-645d833a02fa7b747ad6b225)

Thank you Igor.
