Colin Archer

Colin is a Senior Development Consultant at DSP with 20 years’ experience of analysis, design, and development of bespoke Oracle applications for a wide variety of business functions. Building on his previous experience of Forms and PL/SQL he is now focusing on developing high quality fit for purpose solutions using APEX.

-->

Latest Posts

Feb 27, 2025 9:18:28 AM

Invoking Workflows within Workflows – APEX 24.2

The workflow component was first introduced in APEX 23.2 and can be integrated into your applications to model and run your business processes. I first reviewed the component in a..

Oct 3, 2024 12:50:53 PM

APEX 24.1 New Features Roundup

Over the past few months, we have published several blogs on the new features released in APEX 24.1. In case you missed any of them, you can read them here:

May 14, 2024 12:29:53 PM

Using APEX Workflows

APEX 23.2 introduced the new Workflow Designer, which works with the existing Task Definitions to create workflows and automate business processes. My colleague, James Sanna,..

Aug 23, 2023 2:24:34 PM

Exporting Custom Interactive Reports via REST

On a recent project, I was tasked with developing a module within an APEX application to receive a JSON file via a REST API. This was so it could be manipulated on screen before..

Jan 18, 2023 1:02:51 PM

Setting up OCI Bucket storage and accessing from APEX

I recently needed to set up and use OCI bucket storage for use with an APEX application. Although I found some helpful reference guides out there, they all appeared a little out..

20’s REST Improvements for APEX...so far

Jul 20, 2022 2:08:02 PM

REST Improvements for APEX since 20.1

It’s been a while since I last wrote a blog on REST features in APEX, in fact, it was way back in 2019! Since 2020 there have been five APEX releases, which collectively contain..

Jun 4, 2021 10:45:00 AM

Native Maps in APEX 21.1

Find out how we can help you build solutions using Oracle APEX with our award-winning application development and consultancy services. Version 21.1 of APEX has recently been..

Oct 13, 2020 12:27:00 PM

APEX 20.2 New Reporting Features

Find out how we can help you build solutions using Oracle APEX with our award winning application development and consultancy services . A pre-production version of APEX 20.2 has..

Sep 4, 2020 1:43:46 PM

APEX REST Enabled Forms

Find out how we can help you build solutions using Oracle APEX with our award winning application development and consultancy services. Following on from my previous blog, today I..

Mar 26, 2020 10:00:10 AM

Using REST Data Sources for APEX List of Values

There have been many new REST features and improvements added to APEX over the past few releases, so I thought now would be a good time to take a look at some of the newer REST..