New APEX training in Vienna – APEX Debugging and Performance

Just a quick note: I’ll be holding a 1-day APEX training class on April 21st in Vienna, Austria.

In this training I’ll teach you how to debug your APEX applications, how to find problems and bugs and how to speed up your application.

Interested? Go here and sign up: http://www.aoug.at/Event/413

How to update a custom public theme in Oracle APEX

In the last post I showed how you can upload a custom theme to the instance repository so that all your developers can choose that theme within the create application wizard. And more importantly, subscribe that theme from the theme repository.

Now the next question is how to update that public theme so that all applications can inherit the changes.

My first attempt was to simply go to Instance Administration – Manage Instance – Public (more...)

Creating a custom public workspace theme

The Universal Theme introduced with APEX 5 is immensly good looking and comes with a powerful Theme Roller to customize it.

With that new theme most, if not all, older themes are obsolete.

That leaves us just with a few corporate designs which can’t (or don’t want to) be replaced by the UT.

Now ideally you want your developers to use that custom theme in all applications and also subscribe to that.
Historically I recommended (more...)

APEX in the Cloud Day in Vienna

Are you in Vienna/Austria on February 25th 2016 and interested in APEX?

Then you have to come and join us at the “APEX in the Cloud Day” – reserve your seat right away!

Switching Interactive Report to Icon or Detail View in APEX 5 using Javascript

At yesterdays APEX Meetup in Vienna someone asked if there is a way to switch an Interactive Report programmatically (using Javascript) to Icon / List / Report – View in APEX 5, since gReport doesn’t exist anymore (which could do the job before APEX 5).

Application_BuilderAbove you see an example of an Interactive Report everyone should know: this is the Application Builder listing all pages of an application.

The task at hand is to call (more...)

APEX Developer Addon for Firefox 43+ – now signed

Quick note: I finally managed to get the APEX Developer Addon signed by Mozilla and therefor working again in Firefox 43 upwards.

Please re-download and install, version of the Addon in Firefox is now 2.0.0.49. No changes for Chrome.

Apologies for the inconvenience and thanks for all those mails I got.

New Website for FOEX online

Last year was very eventful at FOEX, which kept me occupied and kept me from blogging. Thankfully I managed to attend a few conferences and stay in touch with the community through Twitter and Slack on apex.world.

FOEX is growing a lot and needed a new website design, so we had a brainstorming meeting and decided to again build it in APEX.

Last week we finally decided everything for the website was ready (more...)

APEX Instance debugging on command line

One of many small enhancements in Oracle APEX 5.0 is a small utility that can be used to help debugging an APEX application from SQLPLUS or sqlcl.

When you download and unzip APEX 5 you’ll find a utilities directory which includes a debug directory:

The debug directory contains 4 SQL scripts:

  1. d0.sql
  2. d1.sql
  3. d2.sql
  4. ds.sql

Now lets take a look at what those scripts are doing:

d0.sql

With d0. (more...)

Differences between Oracle APEX 4.2 and 5.0

If you haven’t heard: APEX 5.0 is out !

And I finally got some time on my hands to do my usual “diff” between the new and previous version to point out all API and View changes.

To me this is a very valuable exercise to absorb all new information and to get to know all new Features of a version. Because everything I find in View and API changes, must also be reflected in (more...)

APEX Developers wanted!

Currently there are multiple positions open for APEX Developers locally in Vienna/Austria.

FOEX is looking for talented Oracle APEX and/or Ext JS Developers, which want to be part of our growing Startup currently serving customers in 13 countries worldwide. Check this link for more.

click-click IT Solutions is also looking for APEX Developers/Consultants. Check this link for details.

Since both companies share a wonderful office you can expect to have also the best possible colleagues (more...)