Using ORDS, REST webservices, PL/SQL and OAuth2 to Build, Deploy and Secure an API
Event: Connect 2022
Stream: APEX, Development/Middleware, Integrations, Security, Tools
In this presentation, through building practical examples, attendees will learn how to build a secured REST API to enable searching on their application. The resulting technology-independent REST API will be usable by both Oracle and by non-Oracle environments alike. Topics to be covered include: – an architectural overview of the creation of ORDS web services in PL/SQL – setting up ORDS for your database schema – defining the search API in PL/SQL – creating ORDS module and templates for the API – management of HTTP return statuses and result pages pagination – securing the API via OAuth2 using ORDS clients, privileges and roles.