APEX 5.0 Early Adopters release available

This morning (for us on CET) brought a surprise from the developers over at Oracle Application Epress headquarters. The Early Adopters release for APEX 5.0 has been made available to the public.
On https://apexea.oracle.com you can request access to the environment. After approval you can start testing all the new features for the upcoming version of APEX.

There are many things to discover, but the most obvious one is the new Grid (more...)

Change an item Label dynamically

Get it? “an item with many hats”… yeah ok.

Need to change the label of an item on-the-fly? When I run my Apex page it renders item labels like this:

<label for="P1_CONTACT_NUMBER">
  <span>Contact Number</span>

If the label needs to change based on another item, I could set the label with the value of another item, e.g. “&P1_CONTACT_NUMBER_LABEL.” and when the page is refreshed it would pick up the new label. But at (more...)

Browser and Session value in APEX

For those of us who have been developing in APEX for a while will understand that the value of an item in APEX is not always what it seems. That’s right; an item has two values in APEX. The first value is the session value that we can store in the database (server side), the second value is the value the end user sees on his screen in the browser (client side). On some occasions (more...)

The Future of Oracle Forms Community Survey

Future of Forms

Take the The Evolution of Oracle Forms Survey Now.

I can hardly believe it but its been over 2 years since we did our original Oracle Forms modernization poll for developers. Boy time  flies when your having fun!  Now we are once again joining with Oracle and the Oracle Forms Community to conduct the “Evolution of Oracle Forms” customer survey. We are doing this survey to really try and determine what are the needs of (more...)

How to reset an APEX process

While I was setting up a demo the other day, I ran into the following issue: My main start page contains a list of customers and that list is created by a call to a (remote) web service. Due to the nature of this service, it takes a few seconds to get a result back - not very slow but slow enough to annoy me. So I looked at ways of caching the web service (more...)

Parallel Development in Apex

Source: http://paulhammant.com/files/multi-branch.jpgMy current client has a large number of Apex applications, one of which is a doozy. It is a mission-critical and complex application in Apex 4.0.2 used throughout the business, with an impressively long list of features, with an equally impressively long list of enhancement requests in the queue.

They always have a number of projects on the go with it, and they wanted us to develop two major revisions to it in (more...)

OTN says I’m an APEX guru :-)

Just before the new year I became a 'guru' - at least as per the measuring stick over at the OTN APEX forum.

I tried to find my tweet when I reached the 'Expert' status, just to see how long it's been - but I couldn't find it - maybe too small a speck in the big data that is twitter.

However, milage varies when it comes to forum usage and I must (more...)

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

Always check out the original article at http://www.oraclequirks.com 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

Fixing phone numbers

An enhancement request I was assigned was worded thus:

“User will optionally enter the Phone number (IF the phone was blank the system will default the store’s area code).”

I interpret this to mean that the Customer Phone number (land line) field should remain optional, but if entered, it should check if the local area code had been entered, and if not, default it according to the local store’s area code. We can assume (more...)

2013 Blog Review

Just like every other tom, dick & harry on the internet, I thought I'd look back at the year that was.
Keep an eye out for interesting tangential and useful links.

A vague attempt at humour

Readership continues to grow. Rapidly. From my first full year (2010) with 5k visits, I'm now at 50k visits & 69k page views for 2013, averaging 70 posts per year - cool stuff!

I've been impressed with the growth (more...)

2014 technology ambitions – just the two

As this the traditional time to layout resolutions for the year here are my 2 database related ones.

To understand more about some of the newer technologies and to advance my use of APEX as a means of providing reporting information around the systems and people I manage.

Having worked with the base Oracle RDBMS, and latterly SQL Server, for around 20 years I must admit that I am not as familiar with such terms (more...)

PhoneGap 3 ebook winners

Late last year Packt Publishing offered 3 e-books to help promote Giorgio's revised edition of PhoneGap 3. People who commented or tweeted the blog post received entries to win.

While I prepared some SQL to randomise selection of winners, I didn't get a chance to arrange the job to be (more...)


AJAX is becoming important in the world of web applications. APEX has provided us a very easy way to create an AJAX process, by using dynamic actions. Using PL/SQL Actions in Dynamic Actions to communicate with the database without submitting the page will suffice in most cases, but the downside (more...)

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 (more...)

Win a free ebook of PhoneGap 3 by Packt

PhoneGap 3 Beginner's Guide
Packt publishing have generously given me the opportunity to give away 3 copies of their e-book PhoneGap 3 Beginner's Guide, by Giorgio Natili.

Details on how to enter are further below.

You don't think you need to be an APEX developer to appreciate this book, (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.


Multitenant Self-Service Provisioning – BETA 2 – No emails out for ADMIN user

What did I mean? Actually, I thought how to rename "ADMIN" user?or How to rename "Email Address" on  Multitenant Self-Service Provisioning? Why I interested in it?

I created New Database by using "ADMIN" user.
I didn't get email about credentials (Because no email address for ADMIN user). (more...)

Multitenant Self-Service Provisioning – BETA 2 – Role

Last post, I posted about Oracle Multitenant Self-Service Provisioning - BETA 2 and read more about what changes have been made in this Beta 2 release.
Users with the PDBA role in the Oracle Multitenant Self-Service Provisioning application can only view PDBs that they created or have been made an (more...)

Multitenant Self-Service Provisioning – BETA 2 – Started to play

Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb.
(Downloaded pdbss_1030.zip and installed)
This version, the Oracle Multitenant Self-Service Provisioning application now runs in (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