Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The most recent is about heterogeneous services (also referenced as HS). Here is the case: We have an Oracle DB instance with some APEX applications and in one of those applications I need data from a MS SQL server database. Not… Continue Reading →

APEX, Application Development, Database Development

While it is very easy to create a “Form and a Report” on a single table or view (just follow the wizard), it is not always intuitive for end users that they should navigate to the form page to remove the record. A nicer solution is the one described by Anthony Rayner in this demo page. This solution uses a… Continue Reading →

APEX, Database Development

One of the most anticipated new features that was introduced in APEX 4.0 was the ability to create your own APEX objects using the plugins framework. Since plugins were new when 4.0 was released there were just a handful of examples available online to help you learn how to create them. Today I’m pleased to announce that there’s a new… Continue Reading →

All Things Oracle Full Articles, APEX, Application Development, Database Development, eBook

Always a good idea to upgrade on a Friday.. not… In the past I did numerous upgrades to the latest APEX release, and never really encountered big problems. It was always very smooth, kudos to the APEX-team. If something went wrong it was mostly my own fault, which I will admit now. Because of the history of going very smoothly,… Continue Reading →


We all read the blog postings about what features were added in Oracle APEX 4.1, like the ones here, here, here and here. But what does that mean on a more technical level? Which Views have changed, which API’s have changed? Inspired by the webinar over here I thought I’d give the Red Gate Schema Compare Tool a try. The… Continue Reading →

APEX, Application Development, Troubleshooting

Understanding is required before success is possible [Dune] old Orange Catholic Bible When you want to hide and display certain regions in an APEX based application based on the selection of the user, for instance when a button or a link is pressed then you can of course use the Region Display Selector, but this takes up a region on… Continue Reading →

All Things Oracle Full Articles, APEX, Application Development

A few months ago we (APEX Evangelists) launched the APEX Challenge, a weekly quiz where you get a question about Oracle Application Express. Next to the fun of answering the questions and see your rank, you will hopefully learn something. To make it a bit easier for the APEX community, to find the site, we looked at a specific url… Continue Reading →


For nearly four years I’ve enjoyed giving back to the Oracle APEX community in various ways such as the Oracle Forums, this blog, talks at various conferences, authoring free plug-ins, and webinars to name a few. Now I want to continue to help out in a different fashion by running for the ODTUG Board of Directors. I believe I will… Continue Reading →

APEX, Application Development

With the recent announcement of the Oracle Database Cloud, it also means Oracle gives a strong message towards the APEX community. Oracle Application Express (APEX) will be included in the Database Cloud. If you look at the features of the Database Cloud, for development it’s all APEX and web services (through the APEX listener). Read the full post at dgielis.blogspot.com

APEX, Database Development, Oracle Cloud

By Matt Nolan, APEX Freelancer Recently I had an inquiry via my website asking whether I was able to create a selectable body chart APEX plugin for a physiotherapy practice so they could easily highlight joint pain and record information against these selected areas. One of the challenging requirements was to allow fine grained selectivity of 16 areas on each… Continue Reading →