Oracle Application Express (APEX) 4.2.5 is now available for download

A new minor release of Oracle Application Express (APEX) has been announced yesterday. Version is now available for download. Check out the accompanying documentation for new features and bugs fixed in this release. You may also find interesting reading Joel's blog posting about Apex 4.2.5.

On HTTP 401 Unauthorized (with Oracle EPG)

Always check out the original article at for latest comments, fixes and updates. It could happen that suddenly your Apex application that has been working for years starts asking for a username and password in order to access the XDB repository. You hit the Cancel button and all you get is:   401 Unauthorized No html, no images, nothing is returned, your app is

Oracle APEX Cookbook : Second Edition

 Oracle APEX Cookbook : Second Edition
Oracle Application Express is the great tool for developing Web Application with SQL and PL/SQL. Users can develop and deploy Web based applications for desktops and mobile devices.  If We will be talking about books about APEX. I mention a book title Oracle APAC Cookbook - Second Edition by Michel Van Zoest and Marcel Van Der Plas. I had a chance as technical viewer on this book. So, I found it is interesting book about (more...)

Bookreview: Oracle APEX Cookbook – 2nd edition by Marcel van der Plas and Michel van Zoest

A few weeks ago Packt Publishing asked me if I would give a book review for the recently released Oracle APEX Cookbook, the second edition by Marcel van der Plas and Michel van Zoest. In exchange I would get the e-book for free, so this can be considered a sponsored blogpost. Even though it is sponsored I will give my honest opinion about it.

The book contains fifteen chapters starting with "Creating a Basic APEX (more...)

Triggering and Handling a Custom Event in APEX

On one of the pages there was a need to refresh a report region when a node in an APEX Tree was clicked. As far as I know there is no built-in method to create a Dynamic Action to a node in an APEX Tree, so this might call for a Custom Event.
If there is a built-in method, please leave a comment :)

Trigger Custom Event

To trigger a Custom Event, change the "link" (more...)



This year, from June 22 - June 26, the best convention in the world, ODTUG’s KScope14 will be held in Seattle, Washington. I am already looking forward to meeting some ‘old’ friends again, creating new friends and seeing some of the best content by presenters from all over the world.

Some of the presentations I am looking forward to:

In the Developer’s Toolkit track:

New publication for Oracle professionals

OTech Magazine Winter 2014If you are working with Oracle software as a developer, DBA or application server administrator, you should read the new OTech Magazine.

The Winter 2014 issue is almost a book: 136 pages of high-quality technology articles by some of the leading experts in their respective fields.  My contribution is the article “From Requirements to Tool Choice” about how to choose the right Oracle development tools (ADF, APEX, or Forms).

And did I mention it (more...)

APEX 5.0 Early Adopter

The long awaited Early Adopter installation is finally available at You can request a workspace here to play around with the new version. I have just been playing around with it for about an hour an from what I’ve seen it’s a big change to what we’re used to since APEX 4.

Not only has the look an feel changed to flat ApplicationBuilder  ApplicationBuilder, but I think the biggest visible change is (more...)

Random XDB authentication problems with Apex and EPG: problem solved? So it seems.

Always check out the original article at for latest comments, fixes and updates. This is the sort of things I hate, because I cannot fully explain why it works the way it does, anyway, here is a short account of what happened: Some time ago I installed Oracle XE 11g on an Oracle Linux VM. Upgraded Apex to 4.2.3 Installed all my applications with little effort if we

human readable URLs in Oracle APEX – Part 3

In the first two parts of this blogpost series we covered the basics and the technique on how to provide nice/friendly/readable URLs for a public APEX Application.

If you haven’t read the other two parts, please go back and read part 1, then read part 2. Done? Ok, lets continue.

Again here the links for two examples: the Sample Database Application which will be used as example in this post and the click-click Website (more...)

human readable URLs in Oracle APEX – Part 2

In the first part of this Blogpost Series we touched some fundamentals and finally listed some options. If you haven’t read it, yet, please do now before continuing here.

The last post ended with me saying I found a way for hrURLs that works with APEX Listener, mod_plsql and EPG.

I haven’t tested the Thoth Gateway, but based on the documentation I’d say it works as well as the mod_plsql way.

Just to be (more...)

Oracle Application Express (APEX) 4.2.4 is now available for download

Somewhat unexpectedly, at least for me, Joel Kallman announced a new iteration of Apex. Enjoy

hrURL – human readable URLs in Oracle APEX

Searching the APEX Forum for nice URLs is as old as Oracle APEX itself, so far without much luck. There is magic switch that forces APEX to create readable URLs.

As part of preparing my Presentation “Going Public” for Kscope 2014 in Seattle, I investigated the available methods on providing readable URLs and found some good ones.

You can check this public APEX website to see how good URLs can look like: (more...)

APEX Tree based on Pipelined Table Function

Representing hierarchical data in an APEX Tree is fairly straight forward, the wizard to create a tree region assists you with that. But when you need to show data from multiple tables, you will need to provide your own query. In a previous blogpost I have written how to achieve (more...)

Tree with Checkboxes: Save the Data – JS Array to PL/SQL

In two previous blogposts I described a method to transform a regular APEX Tree component to a Tree component with checkboxes. The second blogpost described a way to retrieve the data from the database using JSON and AJAX and check the appropriate checkboxes. In this last part of the series (more...)

Install APEX Packaged Application by Importing its SQL Script

If for some reason, you could not install the APEX packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql).

In my case, when installing via the Packaged Applications interface, I got the following error:

Screen Shot 2013-10-02 at 12.06.48 PM

While working (more...)

Tree with Checkboxes – Pre-Select Data with JSON

After you have modified the standard APEX tree to a tree with checkboxes (see this blogpost) you will probably need to find a way to load data from the database and show the values previously checked by the user.
In this blogpost I will show you how to load (more...)

Oracle Application Express 4.2.3 is here

In case you didn't read the news somewhere else, the latest and greatest version of Apex (4.2.3) has been made available for download. Patch set notes include a long list of bug fixes. Thanks to Joel Kallman for the timely announcement.

APEX_MAIL package and views quick reference

Always check out the original article at for latest comments, fixes and updates. APEX_MAIL is the API package for sending emails from Oracle Application Express. In order to be able to execute APEX_MAIL procedures and/or check the related views outside of Apex (from SQL Developer or from (more...)

D-I-Y apex_mail_log maintenance and an Apex feature request

A couple of days ago I submitted a feature request via the Apex Feature Request application because I believe that workspace administrators should be given the possibility of purging the apex mail log if they want to (see feature request AG3A). If you agree with my request, you're kindly invited (more...)