Skip to Main Content

APEX Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

May 16

14:00 UTC   Start Times Around the World


Exposing RESTful Services using APEX and ORDS
Join Doug Gault from the APEX Development Team as he builds, tests and protects a set of RESTFUL services using a combination of the APEX RESTful Services Console and ORDS APIs. We’ll look at protecting REST services using BASIC and OAUTH2 Authentication and review two example PL/SQL code blocks that consumes the protected service.

Session Chat:
Session Slides: with-apex-and-ords

Video Highlights:

Frist 3 Mintues: Introduction
03:06 - Brief Introduction to REST
05:18 - Brief History of REST in APEX and ORDS
08:55 - High Level Overview of the ORDS and its APIs
16:15 - ORDS Enabling an Oracle Schema
19:54 - ORDS AutoREST Description
22:45 - ORDS AutoREST Demonstration
29:03 - Manual REST Service Creation Description
32:32 - Manual REST Services Demonstration
44:20 - Securing ORDS REST Services
45:19 - Common types of Authentication
46:26 - ORDS Basic Authorization Description
49:39 - ORDS REST Basic Authorization Demonstration
53:00 - ORDS OAUTH2 Description
56:30 - ORDS OAUTH2 Demonstration
58:30 - Consuming ORDS REST from PL/SQL
60:00 - Q&A

Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Join APEX developers and product managers for trainings and how-to's, so you can make the most of this amazing tool!

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Doug Gault
Doug Gault, Consulting Member of Technical Staff    
Doug Gault is a Consulting Member of Technical staff at Oracle and works on the Application Express core development team. Doug has written several books on Oracle APEX (published by APRESS Media) and his areas expertise include the Oracle REST Data Services and the APEX REST Services console.
David Peake
David Peake, Senior Principal Product Manager - Application Express    
David joined Oracle in 1993. He spent the first 13 years within Oracle Consulting in Australia, New Zealand, and the United States. In 2006, he joined the Product Development team as the Oracle Application Express (APEX) Product Manager. He presents at many conferences around the world including Oracle Openworld, ODTUG KScope, OGh APEX World, DOAG and UKOUG.
Joel Kallman
Joel Kallman, Senior Director, Software Development    
Joel is the Senior Director of Software Development at Oracle America, Inc., managing the development and product management of Application Express (APEX). He started working with Oracle Database in 1992 and joined Oracle in 1996. Joel's passion is to make customers extraordinarily successful with the Oracle Database, SQL and Oracle Application Express (APEX). He is a proud alumnus of The Ohio State University, College of Engineering, with a Bachelor's degree in Computer Engineering.