Sometimes it works, sometimes it doesn’t …

Recently at a client site I ran into a strange issue. There was an APEX page where you can set some parameters and then a report would refresh according these new settings. But the strange thing was: Sometimes it worked perfectly, but sometimes it didn't. In the latter case one or more of the parameters seem discarded... WTF ??

So I dived into it and looked at the code. The parameter / refresh mechanism was implemented (more...)

Showing a success message after closing a modal dialog

APEX 5 comes with Modal Dialogs out of the box. Very neat. Especially for adding and changing data. And to minimise the number of time a user has to click, it could be useful to add a "Close Dialog" process after the actual data processing. When the data processing fails, the Dialog stays on top showing the error. When data processing runs fine, the Dialog is closed ... without any confirmation. And this might (more...)

Expert Oracle Application Express, 2nd Edition, is out now !

It took a while, but last month the second edition of the Expert Oracle Application Express was released. It is the natural successor of the first edition (duh), but its not just that. Some of chapters are updated for APEX 5, but about half of the chapters are completely new! And that means also half of the authors are new as well. Because this is a joint project, 14 authors, 14 chapters, one goal. And (more...)

Make even more of UKOUG Tech15: APEX 5.0 UI Training – Dec 10th in Birmingham !


APEX 5.0 has been released this spring. People who have already spent some time on this new version know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way.
 The definition of user interface components in APEX 5.0 is very (more...)

APEX 5.0 UI Training – Looking back and towards the future

This week Dimitri Gielis and I ran a training day about all the new APEX 5.0 UI features. We had a full room with 20 enthusiastic attendees from 4 different countries. We covered some general APEX 5 UI features, the Universal Theme, Responsive Grid layouts, Template Options, Theme Roller, Theme Styles and bringing it all together using some advanced features. See the website for more details.
And - as it was the first time (more...)

APEX ReadOnly Pages – The easy way

If your Oracle APEX Application requires different types of access - full access or readonly - for different types of users, you can specify a Read Only Condition on Page level (or Region, Item, Button, etc.). 
You can set an Authorization Scheme on Application level, so it'll be applied to all pages. So if you have an Authorization Scheme named 'User Can Access Page' defined by a PL/SQL function like this:

return apex_authorization. (more...)

Announcement: APEX 5.0 UI Training – May 12th


APEX 5.0 will be released between now and the end of May. People who have already spent some time on the Early Adopter versions know this version is packed with new features aimed to make APEX developers even more productive, like the Page Designer.
Another striking new subset of features is aimed at creating better looking user interfaces for your APEX applications in an easy and maintainable way. 
The definition of user interface (more...)

Riga Dev Day 2015

While waiting at the airport for my plane back to Amsterdam, I have some time to write down my experiences of the last few days in Riga.
After arriving in the hotel, I walked to the old part of town and strolled around. The old part looks very medieval (it is - so no surprises there) with cobblestone streets, old houses and very few cars. Nice!
Then back to hotel, in time for the "official" (more...)

Can you build business critical applications with APEX?

Now and then this question pops up. And today this question was delivered to my mailbox again. A customer is busy starting a project to replace a current Oracle Forms application. So he asked Oracle and one of the Oracle partners: What should we use, APEX or ADF? A valid question that has been asked - and will be asked - by numerous customers. 
Of course, there is only one correct answer and that (more...)