Install latest patch of APEX 4.2 (4.2.5)

A few days ago Oracle brought out a new patch for APEX 4.2, this will be the latest version of this build, the next version of APEX will be 5.0.

If you already have APEX 4.2.x installed you can download a patch from support.oracle.com, the patch number is 17966818.

If you have an earlier version of APEX you can download the full version of APEX and install that.

APEX Listener => Oracle REST Data Services


Yesterday a new version of the Oracle APEX Listener was released. The new version is 2.0.6... and the biggest change in this release is the change in name. From now on we won't speak about the "APEX Listener" anymore, but we speak about "Oracle REST Data Services".

The name explains more what the piece of software is doing and it will be less confusing for non-APEX people. Many people thought about the Database (more...)

Some help with the Oracle APEX Theming Competition 2014

ODTUG announced a few days ago the Oracle APEX Theming Competition.

Make an awesome APEX theme and you may win some cool prices!

In the Learning Resources on the ODTUG site you will see a reference to my presentation of last year "Advanced Responsive Design in APEX". In that presentation I showed a lot of live demo's from different aspects of Responsive Design: here's a quick overview of what I covered:


I made (more...)

The evolution of APEX Evangelists

Every year we at APEX Evangelists come together to discuss the past and the future of the company.
In the past 7 years a lot has changed; the APEX market changed, the community changed, we personally changed, ...

We really like APEX, we are all passionate about it, we love to have technical discussions with each other and come together to share our thoughts, but we also like our independence and make our own trade-offs company (more...)

APEX 5.0 (EA): CSS Calendar

APEX 5.0 allows you to create a new Calendar type, called CSS Calendar.

The CSS Calendar is based on Full Calendar 1.6.4, at the moment of writing, the current latest production release. The creator of this JQuery plugin, Adam Shaw, is currently working on version 2. A few days ago he released beta 2. It remains to be seen which version of Full Calendar will make it in the final (more...)

APEX 5.0 (EA): Feedback Page

One of the first things I do when creating a new application is enabling the feedback mechanism in combination with Team Development.

Click the Create Page button in Application Builder and select "Feedback Page":


The next step looks like this:


The Page Mode can now be set to Modal, so instead of a popup it will render as a modal.

Note that in the EA1 version there are some known issues with the Feedback Page, (more...)

APEX 5.0 (EA): Creating a new application

Lets see how creating a new Database application works in APEX 5.0 and what was changed compared to APEX 4.2.

In the Application Builder you start by hitting the Create button.


There are a couple of improvements here:

  • You'll see APEX 5.0 includes a complete new set of icons which are flat and fresh and immediately give you an insight what the button is doing. This is throughout the entire release.
  • The (more...)

APEX 5.0 (EA): Overview

Now that APEX 5.0 EA is out, it's time to do a deep dive in the new features of this early adopter (EA) release.

Overall this new version of Oracle Application Express tries to put even more power and speed in the development. The UI is made simpler and cleaner with a fresher look and feel.
Not every part of APEX got an overhaul in EA1, it remains to be seen if in EA2 (more...)

APEX 5.0 (EA) Page Designer video’s

APEX 5.0 early adopter is about to be released in the public.

Requesting a workspace is not working yet at the time of writing this post, but I expect it can be opened every moment now.

APEX 5.0 carries many new features, one of the biggest is the new Page Designer which should increase developer productivity even more. David Peake recorded some videos, here's the APEX 5.0 Page Designer Overview:



You find (more...)

Increase post back size in Glassfish

I created a small mobile APEX app for my football team where they can upload pictures to the app.


Sometimes saving the picture worked, sometimes it didn't. If it didn't work I hit the following error: "Post too large". It turned out that my Max Post Size in Configurations - server-config - Network Config - Network Listeners - http-listener-1 under HTTP was set too small.


After increasing it worked like a charm.

Start learning a new Oracle technology

I found it very interesting to read Tom Kyte's New Year resolutions for 2014.

"Learn something new about Oracle almost every day"

"Learn a new technology outside the comfortable realm of Oracle Database".

Resolutions I try to follow myself every year...

I love to try and integrate different technologies with Oracle APEX. Looking back at the last two years, just from the Oracle stack alone, in 2012 I played around integrating APEX with E-Business (more...)

Getting started with Oracle Application Express (APEX)

There're still people just starting with APEX, so here's a quick post which might help them.

On apex.oracle.com there's a nice section about how to get started with Oracle APEX.


I think most important is to just start and play with APEX. Creating an account on apex.oracle. (more...)

Time to update your APEX development environment

In the last days (and weeks) Oracle has been updating many of the tools a typical APEX Developer uses day-in-day-out.

Here's a graphical overview of a typical APEX configuration:



Following desktop tools got updated:

  • my favourite connection to the Oracle database
  • a great SQL and PL/SQL (more...)

Fix Inbox mail issue in Mavericks

When updating my OS X to Mavericks, the Mail app started to behave differently for my GMail (Google Apps) accounts.

Whenever I moved a message from my Inbox to a folder the message wasn't removed from my Inbox. On the forum and on some sites (e.g. DigitalTrends) the (more...)

APEX book: Oracle APEX 4.2 Reporting

A few weeks ago a new Oracle APEX book was released called Oracle APEX 4.2 Reporting by Vishal Pathak.


I was one of the reviewers of the book and I really liked the content. The book covers many different areas of APEX and combines it with other knowledge (SQL, (more...)

APEX 4.2.3 available for download

A new patch set of Oracle Application Express (APEX) is available for download, the latest version of APEX is now 4.2.3.00.08.

As we are used to patch releases; it contains bug fixes, updated external libraries and updated or new packaged applications. This release is not different; for (more...)

APEX Mobile – iPhone 5 Web App in Fullscreen

The default Mobile Theme (50) in APEX renders just fine in Safari. It uses the full height of my iPhone 5, but when I added the app to my Home screen and ran it from there, it didn't render in fullscreen mode.

Turns out that the iPhone 5 doesn't like (more...)

Make APEX Plugin source read/write

I really like the Flot Pie Chart plugin that came with the APEX sample applications (see this blog post in which apps this plugin is used).

But when I wanted to make changes to it, I couldn't... the PL/SQL Code was read-only.


To make the source read/write again you need (more...)

Upgrade Oracle DB 11gR2 with APEX to 12c

Now that Oracle Database 12c is available I upgraded my VM to try it out. The installation went very smooth and I was up-and-running in no time!


My virtual machine had Oracle 11gR2 installed with the latest patch of APEX 4.2.

Here are the steps I followed:
- downloaded (more...)

OTN Forums updated

Today the OTN Forums where updated. The site is still in read-only mode as they are fixing some issues. 

This is how the new APEX Forum looks like:


I need to get used to this new look and feel, but it looks more up-to-date design wise.

You can expand (more...)