This is part one in a series of blog posts
about how to install Oracle 11g Express Edition (XE) with Oracle Application Express (Apex) on a CentOS Linux server, with Apex served by Oracle REST Data Services (ORDS) running on top of Tomcat and Apache.
Provisioning the server
First of all, we need a server to install the software on. There are many hosting providers that offer cheap Linux servers. I have been trying out (more...)
I am writing a series of blog posts about how to install Oracle 11g Express Edition (XE) with Oracle Application Express (Apex) on a CentOS Linux server, with Apex served by Oracle REST Data Services (ORDS) running on top of Tomcat and Apache.
This is perhaps better explained with an illustration of the setup:
Best of all, this setup consists only of free (license-free) software, and as you will see in this series of blog (more...)
As with the Alexandria PL/SQL Utility Library
, the source code for the Thoth Gateway, a mod_plsql and Apex Listener/ORDS equivalent for Microsoft IIS, now has a new home on GitHub
. This should make it easy for anyone to look at and perhaps contribute to the code.
If you don't care about the source code, you can head straight to the releases page
to download just the binaries. Updated installation instructions for IIS 8 will (more...)
The PL/SQL Utility Library, codenamed "Alexandria", now has a new home at GitHub
. This will make it easier to collaborate on the project. If you want to contribute, just fork and submit a pull request.
The liibrary contains around 50 PL/SQL packages as well as a few types. There are no table dependencies, which reflects the general-purpose nature of the utilities. Jeffrey Kemp has a great guided tour of the library
which highlights some of (more...)
As mentioned in my previous post
about the Thoth Gateway
, a mod_plsql and Apex Listener alternative that runs on IIS, the goal for the next release of the gateway (tentatively called version 1.4.0) is to change the Oracle Data Provider for .NET (ODP.NET) from the "Unmanaged" to the "Managed" driver
. By using the Managed (pure .NET) driver, the installation of the Thoth Gateway becomes even simpler, because it removes the need (more...)
In my previous blog post
, I took a look at the new APEX_JSON package that ships with Apex 5.0 and its capabilities for parsing JSON.
In this blog post, I am going to look at how the APEX_JSON package can be used to generate JSON from data in your database using PL/SQL.
There are multiple ways of creating JSON output using the APEX_JSON package. There are several overloaded write() procedures which can output (more...)