What do you do in a situation where you are developing with a low-code or no-code framework like Oracle Application Express where there effectively is no source code to scan? The answer is, "it depends."
APEX
APEX Authentication with a Smart Card – Part 3 (Application)
Authentication In my previous two posts, I discussed configuring the Apache web server and the APEX Workspace for smart card authentication. With those in mind, I will now look at basic smart authentication within an APEX application. In this architecture, individual APEX applications may now authenticate users through one of two methods: HTTP Header Variable: … Continue reading APEX Authentication with a Smart Card – Part 3 (Application)
APEX Authentication with a Smart Card – Part 2 (Workspace)
Welcome to the second step in the process of configuring Oracle APEX for smart card authentication. In my previous post I demonstrated how to configure an Apache HTTPD server to query a smart card and place the user's certificate Common Name into a header variable named SSL_CLIENT_S_DN_CN. In this post I will describe how to … Continue reading APEX Authentication with a Smart Card – Part 2 (Workspace)
APEX Authentication with a Smart Card – Part 1 (Web Server)
I have written previously on how much I dislike password maintenance. Every chance I get to enable PKI certificate authentication, I take it. Most of my career I have worked in environments where certificate authentication was expected, if not explicitly required, so it wasn't a big leap for me to look at configuring Oracle APEX … Continue reading APEX Authentication with a Smart Card – Part 1 (Web Server)
High Availability Architecture for Oracle REST and APEX
This guide includes step-by-step instructions to install and configure the Apache HTTPD, Tomcat, Oracle REST Data Services, and Oracle Application Express (APEX) technology stack within a simple, highly available infrastructure. It also describes basic HTTP Header-based user authentication and authorization configuration within an APEX application built within the stack.
APEX Patches and NLS_LENGTH_SEMANTICS
I'm going to post this as a reminder to myself as much as anything else. A couple of times - most recently this week - I've had to apply patches for Oracle APEX into various databases that I work with and received the following error almost as soon as the apxpatch.sql script started to run: … Continue reading APEX Patches and NLS_LENGTH_SEMANTICS
How to Load Large WebSheets into APEX
A few years ago I started keeping most of my system documentation in APEX websheets. It's great for keeping things organized and readily available no matter how I'm accessing my work network (on-site, VPN, etc.). A lot of my installation documents have embedded screenshots, and the png files are attached to the websheet as annotations. … Continue reading How to Load Large WebSheets into APEX
APEX Mystery Solved
I have used Oracle APEX in various capacities since version 3. Since Oracle introduced their packaged applications in version 4 I have played around with most of them from time to time and currently use several of them in my daily work. P-Track, ORAchk, WebSheets and others make my job a lot easier, and the new … Continue reading APEX Mystery Solved