Chapter 1. OHS, EPG, and APEX Listener Compared

By John Edward Scott

When I first started using APEX, I didn't really have a choice when it came to deciding which web server to use; in a similar vein to the often-quoted Henry Ford ("any colour as long as it's black"), it was a case of "Use any web server as long as it's the OHS". The OHS is the commonly used name for the Oracle HTTP Server.

However, as with all things technology related, times change. Oracle 9i Release 2 brought XML DB and with it an embedded web server. As of Oracle 10g Release 2, this embedded web server can be used as an embedded PL/SQL gateway to run PL/SQL via a browser. It is commonly known as the EPG (Embedded PL/SQL Gateway) and controlled via the DBMS_EPG package.

So, things ...

Get Expert Oracle Application Express now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.