Skip to Main Content

Explore Oracle PL/SQL

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

Header container

September 08, 2020

14:00 UTC   Start Times Around the World

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.


PL/SQL and the Art of OCI Management
Special guest Robert Pastijn, a member of the Database Platform Technology Solutions group, will share with us how he went about building a set of PL/SQL APIs to help manage Oracle Cloud accounts and services. He initially did this to help the database team manager upwards of 60 different cloud accounts under OCI Classic. Then he upgraded his API to take advantage of APEX_WEB_SERVICE package and apply it to OCI services. These APIs are used in Oracle LiveLabs.

01:46 Introduction and overview
02:50 The backstory: managing 60+ domains for database team
05:36 Making to move to PL/SQL, REST and APEX APIs
06:58 The joy of APEX_WEB_SERVICE, with jokes!
09:09 Using JSON_TABLE to make your JSON data relational
05:40 Quick review of REST
11:05 Encapsulating inside a PL/SQL function, adding screens in APEX
15:12 Downside of OCI Classic REST APIs
16:38 Making the switch from OCI Classic to OCI
19:06 Implementing signing via PL/SQL (and Java)
27:36 Improving signing with DBMS_CLOUD
30:37 Always Free Oracle Cloud reminder
30:58 Summary
33:13 Q & A: Use terraform? Access APIs from C++? And more

Your Experts

    Robert Pastijn

    Robert Pastijn   

    Working with Oracle since 1996 and working for Oracle since 2000, Robert has always focused on the Database and the underlying operating system and hardware. He installed one of the first RAC clusters on 9i, deployed the first Exadata in the Netherlands, and now helps customers and partners through online trainings and on-site workshops.
    Chris Saxon

    Chris Saxon   

    Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.