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. The application itself was straight forward but contained a significant amount of data entry for the users. The aim was to ensure that should a user’s APEX session close unexpectedly […]

APEX, JavaScript APEX, Development, JavaScript / June 5, 2018

Read More

Application Support with APEX Applications: Looking After the Users when Development has Finished

Although at Explorer we spend most of our time creating brand-new bespoke APEX applications or completing Forms to APEX projects; sometimes we are asked to work on and/or support an existing APEX application, both for external clients and for our own internal systems. Having come from a more support orientated background where I have spent […]

APEX, How to, Support APEX, In House, Support, Team Development / April 18, 2018

Read More

Introducing APEX TabLock

A little side project of mine is developing new features for a chrome extension which provides extra functionality for the APEX developer. The chrome extension is called TabLock and the name derived from its original purpose, which is to help prevent accidental movement of APEX page designer tabs. However, I am aware that this extension […]

APEX, Blog APEX, APEX 5.0, APEX 5.1, Chrome / January 17, 2018

Read More

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 you how to authenticate calls to protected Web Services and how to process paginated JSON response data. Typically the Web Services would be […]

Blog, Explorer, How to, ORDS APEX, OAuth2, ORDS, RESTful / January 11, 2018

Read More

Options For Loading Excel Data Into APEX Applications

Excel is still widely used across many organisations as a standard reporting tool, often being used as a substitute for small databases. As a consequence, it has become necessary to load Excel data into APEX applications. At the UK OUG TECH17 Conference, I introduced a number of options available to help import Excel data into APEX […]

APEX, Blog, TECH17, Why use APEX APEX, Excel / December 21, 2017

Read More

APEX & Search

This year, we have been looking into the best way to deliver search capabilities in an APEX application. Customers are used to searching in Google and often want the same functionality in their business application.  While we don’t have the resources and years of research that Google have, we can take some ideas from them […]

APEX, Blog APEX, Search / November 30, 2017

Read More

ORDS, OAuth2 & Web Services in APEX – Part 2

Protecting Web Services with OAuth2 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) and show you how you can protect them to ensure they can only be accessed by […]

Blog, Explorer, How to, ORDS APEX, OAuth2, ORDS, RESTful / November 13, 2017

Read More

ORDS,OAuth2 & Web Services in APEX – Part 1

Creating your first Oracle REST Web Services 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 them with OAuth2 and how to test them with a REST client. The second […]

Blog, Explorer, How to, ORDS APEX, OAuth2, ORDS, RESTful / October 30, 2017

Read More

Generating PDF and Word Documents from an APEX application

Generating PDF and Word documents from an APEX application is a request that we get all the time. There are many great third party tools to help you do this but in this blog post I’m going to focus on PL/PDF, which is the tool that I used most recently for customer work. PL/PDF is […]

APEX, Blog, Reporting APEX, reporting / September 26, 2017

Read More

Something big is coming

“Something big is coming” @OracleCloud tweeted on 20 July 2017 along with a 12-second video that featured: The words: SOMETHING BIG IS COMING The date: 26.7.17 The brand: ORACLE All set to a roaring soundtrack and a rumbling fade-out animation between slides. Something big is coming pic.twitter.com/uSzWTuKtj9 — Oracle Cloud (@OracleCloud) 20 July 2017 What […]

APEX, Blog, Cloud APEX, Cloud, Database, upgrade / August 8, 2017

Read More

Next Page »

Featured Posts