Colin Archer

Colin is a Senior Development Consultant at DSP-Explorer 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

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..

Read More

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..

Read More

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..

Read More

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..

Read More

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..

Read More

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..

Read More

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..

Read More

How Do I Access My Free Oracle Cloud Database

If you have created a free database in the new Always Free Oracle Cloud Tier, you can use the provided web version of SQL Developer to gain access to your schemas for development.

Read More

Creating & Consuming Web Services in APEX

Last December at Tech 18 and then again at this year’s UKOUG Midlands Tech Event, I gave a presentation (including live demos) on how to create and consume Web Services in APEX.

Read More