Best Practices for Building ORDS PL/SQL-Based REST APIs

Introduction Oracle REST Data Services (ORDS) is a robust and highly scalable tool for exposing REST APIs on top of the Oracle Database. ORDS has several features that allow you to quickly create REST APIs, not least of which is the ability to create...

blog.cloudnueva.com11 min read

#oracle #ords

Responses2

Markdown supported · ⌘↵ to post

JA

Jose Aróstegui

Dec 3, 2024

Great post Jon, sure I'll apply your recommendations to my customers.

Don't you like the privileges/roles/mapping standard so you don't mention it? You skip the use of it with your custom tables (system_permissions)?

Thanks!

Hi. I find that Privileges/roles mapping works well for allowing access to certain web services but not as well for allowing access to specific data within a web service. This is why I went with my own tables in this case.

JD

Jon Dixon

APEX, ORDS & the Oracle Database

Dec 4, 2024

OG

Osvaldo González

Oracle APEX, PL/SQL, JAVA SE, JasperReport

Jul 20, 2023

Excellent post as always, quite useful information

JD

Jon Dixon

APEX, ORDS & the Oracle Database