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

Oracle Cloud: Universal Credits. What you need to know…

In September 2017, Oracle announced a change to their Cloud pricing and transaction model for end users and partners alike. The change was born out of poor customer experience with contracts and billing on their previous model along with frequent internal challenges to provide a streamlined “wash, rinse, repeat” billing and payment mechanism for consuming […]

Cloud, How to, Licensing Cloud, Licensing, Oracle Cloud / March 21, 2018

Read More

APEX Interactive Grid: Preventing Lost Updates & Record Locking

I was recently asked about the Interactive Grid (IG) configuration settings that are associated with Locking and Preventing Lost updates. “Aren’t they the same thing?” I was asked… Actually, no; they are not the same thing. However, they are both there to protect your data and therefore it is worth spending a little time to explore […]

APEX, Blog, How to / February 12, 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

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

bg-goldengate

Oracle Goldengate or Dbvisit Replicate?

Oracle Goldengate release 12.2 Versus Dbvisit Replicate release 2.9 These two products offer data capture functionality and replication between multiple Database environments covering both Oracle SE and EE versions. They essentially operate by reading the source Database redo logs and pushing the data changes across to the target Database. However, there are some Important differences […]

Blog, Explorer, How to Data Replication, Dbvisit, Goldengate / October 23, 2017

Read More

Using Oracle Cloud for Database Upgrade

Use of Oracle Cloud for Database Upgrade and Testing The Oracle Cloud provides a comprehensive set of services that can be used for fast and efficient data migration & testing between different Database versions. The notes below are based on customer upgrade project involving a 10TB Oracle 11gR2 release to 12c. Introduction The production Database […]

Cloud, How to Oracle Cloud / October 11, 2017

Read More

A Review of Interactive Grid in APEX 5.1.1

A Review of Interactive Grid in APEX 5.1.1 This blog has been a long time in the making… Of course before writing a blog on any subject, you have to do your research. In my case, my research involved creating dozens (maybe in to the 100s) of Interactive Grids (IG) and writing a new Explorer […]

APEX 5.1, How to, Review APEX 5.0, Development, Interactive Grid, reporting, upgrade / March 29, 2017

Read More

Dynamic Theme Style in APEX 5.1

Dynamic Theme Style in APEX 5.1 One of the new features of APEX 5.1 is the introduction of APEX_THEME API which enables you to change the application theme style by user. A very nice APEX 5.0 feature is to allow users to change the theme style using the APEX_UTIL.SET_CURRENT_THEME_STYLE procedure (deprecated in 5.1) but this change […]

APEX 5.1, Explorer, How to Development, Style, Universal Theme / March 28, 2017

Read More

Next Page »

Featured Posts