Back

How to Get Secure Web Services (SSL/HTTPS) and Oracle APEX Working

Learn How to Call Secure Web Services (SSL/HTTPS) from Oracle APEX applications!

More and more APEX developers need to call (consume) web services from their applications.  What environment changes are required to support a secure web service call?

In this four-part tutorial Oracle Certified Master DBA John Watson, SkillBuilders Director of Oracle Database Services, will demonstrate how to configure the Oracle Database environment to allow external connections and recognize and accept vetted digital certificates.

This free training is segmented into several separate lessons:

  1. Introduction / Agenda (1:00) (click on video below)
    John describes what we are trying to achieve and provides an overview of the steps required. click to read the Transcript (click to read the Transcript)
  2. Demonstration – Create an Access Control List (1:08)
    To allow APEX (i.e. Oracle Database) to make an external call, someone (typically the DBA) must create an ACL with dbms_network_acl_admin.append_host_ace. click to read the Transcript
  3. Demonstration – Using the orapki Utility to Add Digital Certificates (3:57)
    The orapki utility must be used In order for the Oracle Database to recognize and accept the digital certificates from your desired web services. John demonstrates how in this lesson. click to read the Transcript
  4. Demonstration – Test the Secure Web Services Call (1:41)
    John demonstrates how he tests the web services call over SSL / HTTPS. click to read the Transcript

Date: Sep 6, 2016


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.