Presentation slides for my presentation at DOAG 2015 – Apache – ORDS Setup for Production Environments

Hi guys,

here you can find the slide, the config files and installation steps for my presentation at the DOAG conference in Nürnberg on 18.11.2015:



DOAG Conference Presentation Summary Finished

Hi guys,

today was the deadline for uploading the four-page abstract / summary of my presentation at the German Oracle conference in Nürnberg:

If you still have to upload yours, hurry up ... only a few hours left ;).

You can have a look here (it is German though ;). 

See you in Nürnberg in November.


My Nomination for the Oracle Database Developer Choice Awards

Actually this came as a wonderful surprise ... I have been nominated for the Oracle Database Developer Choice Awards:
I have basically devoted my entire work life to build solutions based on Oracle technology ... and you can build some pretty cool stuff with it. I have always enjoyed building software that makes a difference ... and even more so share to what I have learned and support and inspire others to do the same. (more...)

Presentation slides for my ORDS talk at KScope 2015

Hi guys,

in June I gave a talk at the ODTUG KScope conference regarding the optimal setup of Oracle ORDS for Oracle Application Express: Setting Up the Oracle APEX Listener (Now ORDS) for Production Environments

You can access the slides certainly through the ODTUG site. They have even recorded the presentation and made it available to their members.

This seems to be a good investment for $99 per year for a paid membership, because now (more...)

APEX Connect Presentation and Download of the sample application

Hi guys,

I have just finished my presentation on the smaller new features of Oracle Application Express 5.0 here at the APEX Connect conference in Düsseldorf ... it was a blast :).

You can download the slides and the sample application here:


APEX Summer School 2015 – Online Webinare

Im Rahmen der APEX Summer School 2015 ( Twitter Handle: #apexsummer2015 ) werden wir 9 kostenlose Webinare zum Thema APEX 5 mit den Experten aus dem deutschsprachigen Raum durchführen:

Vielen Dank an Carsten Czarski für die Einladung und Organisation! Nicht zuletzt auch vielen Dank für die klasse Homepage des Webinars, alles 100% APEX 5 out-of-the-box! Ein einfaches und dennoch wirkungsvolles Beispiel dafür, was standardmäßig mit APEX 5 möglich ist:

APEX 5 ist seit letzter Woche (more...)

Slides from my presentation at APEX World 2015 in Rotterdam

Hi guys,

I had a great time at APEX World in Rotterdam, it was a wonderful event. I could meet up with my friends and learn a few new tricks, too :).

Here are the slides from my presentation about the many smaller new features of Oracle APEX 5.0. And I could only cram like half of the good stuff that I found into this 45 min. session.

About 70 people attended the (more...)

Professional support offering for the JasperReportsIntegration toolkit officially announced

You are using the free tool JasperReportsIntegration from Opal Consulting and you might be struggling with setting it up and integrating it into you own APEX applications?

Now you have somebody to talk to!

Already several years ago I have built this software for my own reporting needs in a project for a client of mine.

Then I wrapped it up, documented it and gave it to the incredible and wonderful Oracle APEX community to (more...)

APEX 4.2 Best Practices Training am 26.05-28.05.2014

Wußten Sie schon, daß in APEX 4.2 alleine 130 neue Features implementiert wurden, die uns Entwickler SOFORT produktiver werden lassen und das Leben erleichern?

Auch wird jedes Release von APEX immer sicherer, es kommen immer wieder neue Security Features hinzu.

Das alles hilft uns jedoch nur, wenn wir diese Features überhaupt kennen und optimal einsetzen!

Seit 2006 bauen wir jeden Tag Applikationen mit APEX für unsere Kunden, ja genau - an jedem (more...)

JasperReportsIntegration – Full path requirement and workaround

I have just posted an answer to a question that seems like a bug in the JasperReportsIntegration toolkit, that you have to use absolute paths for referencing images or subreports, which is typically a bad thing.

Don't know exactly why it doesn't work, but there is a workaround for that:

Hope that helps,

First blogpost at my own hosted wordpress instance

I have been blogging at for quite some years now ... and many people have rather preferred wordpress to blogspot, I can now understand why :).

It is quite flexible and easy to use and there are tons of themes available ... really cool ones.

The main decision to host my own wordpress instance was in the end motivated by different means. I have created two products and they needed a platform to be (more...)

Oracle APEX Listener – support for Apache Tomcat

The Oracle APEX listener is one possible gateway to run Oracle Application Express besides the Oracle http server (OHS), the embedded pl/sql gateway (which is the http server included in the Oracle database as part of the XML DB) and other open source alternatives.

Being implemented as a J2EE application it needs a servlet container to be deployed in. Finally, due to popular customer demands, the Apache Tomcat servlet container is (again) supported. Many customers (more...)

Upgrading the JasperReports libraries to 5.2.0

Would you like to upgrade your existing JasperReportsIntegration with the 5.2.0 libraries of JasperReports?

As of now this already seems to be not the most current version, JasperReports has already moved on to 5.5.0. But since I have already created the 5.2.0 package a (more...)

Oracle APEX 4.2 New Features und Tipps aus der Praxis – Neuer Kurs am 11.11.2013

In diesem November werden Denes Kubicek und ich wieder einen Kurs zu Oracle APEX in Bensheim abhalten:

Oracle APEX 4.2 New Features und Tipps aus der Praxis

Wir werden diesmal viel über den APEX Listener, Einsatz von jQuery und über Restful Web Services reden und natürlich, praktisch üben.

Darüber (more...)

DOAG 2013 Development in Bonn am 19. Juni

Am 19.Juni 2013 findet die nächste DOAG Development Konferenz in Bonn statt, diesmal mit dem Thema:

„Agile and Beyond – Projektmanagement in der Oracle-Softwareentwicklung“

Das Motto der zweiten Auflage der Community Konferenz steht fest: Die effektive Durchführung von Softwareprojekten steht thematisch im Zentrum der Konferenz für Entwickler, Softwarearchitekten und (more...)

How to locate all interactive reports in my application?

Today my client decided to remove the email functionality from all interactive reports in their APEX application.

I could step through all the pages of my application and check whether there are any interactive reports used. This very manual approach can take some time and I can make mistakes by (more...)

Oracle Application Express 4.2.2 Patch released

Just yesterday, the most recent APEX patch set has been released. It is Release The full version just as well as the patch set to apply to a 4.2.0 or 4.2.1 instance can be downloaded from here.

The full details can (more...)

Join me at ODTUG’s Expert Panel – Oracle Application Express

In May, I will take part in one of ODTUG's webinars:

Tuesday, May 14, 2013 12:00 PM - 1:00 PM EDT

ODTUG's Expert Panel - Oracle Application Express

Panelists: Dietmar Aust (Opal Consulting), Roel Hartman (APEX Evangelists ), Dan McGhan (Enkitec)
Moderator: Patrick Cimolini (Patrick International APEX Consulting) 


How to make your browser save your password

Typically and for good security reasons the password manager from either Firefox or any other browser will not prompt you to save the password for the login screen of the APEX workspace or any of your own APEX applications.

Why? The APEX team implemented the login page with the HTML (more...)

APEX Training 15.04. – 17.04.2013

Wie jedes Jahr in den letzten sechs Jahren, veranstalten wir (Denes Kubicek und ich) unser

Oracle APEX: Knowhow aus der Praxis

Training in Bensheim an der Bergstrasse. Wir werden unsere bisherigen Themen überarbeiten und einige neue Themen hinzufügen. So werde ich auch folgende neue Themen in das Programm der (more...)