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

Oct 7, 2019 9:47:38 AM

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.

Jul 15, 2019 2:36:19 PM

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.

Jan 21, 2019 4:27:23 PM

What is the Oracle Forms Standalone Launcher?

Find out how we can help you migrate your Oracle Forms applications to Oracle APEX with our award winning application development and consultancy services. I recently attended the..

Dec 20, 2018 1:24:41 PM

Making an APEX Wizard Clickable

Find out how we can help you build solutions using Oracle APEX with our award winning application development and consultancy services . Recently I was at the Tech 18 conference..

Jun 5, 2018 4:30:05 PM

Adding an Auto Save Feature to an APEX Page

Recently I was tasked with adding an auto save feature to an APEX page for a questionnaire style application I was developing for a customer.

Apr 11, 2018 12:23:17 PM

New REST features of 18.1 (Early Adopter 2)

I recently published a set of blogs on the subject of ORDS, Outh2 and Web Services in APEX 5.1. In part three (available here) I detailed how to use a REST Service as the source..

Jan 11, 2018 10:34:01 AM

ORDS, OAuth2 & Web Services in APEX – Part 3

Calling Web Services from APEX The following blog will show you how to call GET method Web Service from an APEX 5.1 application and extract the response data. It will also show..

Nov 13, 2017 12:05:31 PM

ORDS, OAuth2 & Web Services in APEX – Part 2

In my previous blog, I took you through how to create RESTful Web Services with ORDS and how to test them with a REST client. This blog will build on those Web Services (Fig.1)..

Oct 30, 2017 10:08:26 AM

ORDS,OAuth2 & Web Services in APEX – Part 1

I recently gave a presentation on how to get started with Web Services at the UKOUG APEX SIG in London. The first half covered how to create Web Services with ORDS, how to protect..

Mar 13, 2017 12:13:12 PM

Customising chart colours in APEX 5.1

Find out how we can help you build solutions using Oracle APEX with our award-winning application development and consultancy services. One of the new features of APEX 5.1 is the..