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

APEX 5.0 – New Features Training

Unser Training startet in knapp drei Wochen. Es ist zeit sich anzumelden. Wir (Dietmar und Denes) haben Tobias Arnhold eingeladen und er erzählt über das Thema Migration auf APEX 5.0. Tobias ist einer der wenigen Betatester von APEX 5.0 in Deutschland gewesen und hat die wertvolle Erfahrungen damit gemacht, die er mit uns teilen wird.

Unsere Themen zu APEX 5.0 sind zahlreich und vielfälltig. Wir decken fast alles wissenswertes ab:

1. Page (more...)

APEX 5.0 Universal Theme Bug – Update

The APEX team came up with a temporary fix for this issue. Please visit this forum posting for all the updates on the issue. Basically, you need to run a small function on page load. The solution is also described there.

By the way this is one of the three bugs I have discovered so far.

APEX 5.0: Universal Theme Migration Guide available!

Do you want to use the new Universal Theme for your existing applications? Then you should definitely have a look at the Universal Theme Migration Guide my colleagues Shakeeb Rahman and Tim Chambers have just published.

APEX 5.0 Universal Theme Bug

The problem I described here is strange. In my case and I tested it on several laptops with many browsers and multiple installations, appears to be a Universal Theme related bug and occurs in some specific constellation - in my case on Windows 8.1 running FireFox or Google Chrome (IE11 works as expected). I noticed this problem while working on the Tabular Form chapter for the new Expert APEX book. The first thought I (more...)

APEX 5.0: Custom Favicon for Applications using Universal Theme

For applications which are using Universal Theme you don’t have to modify the Page Template anymore if you want to replace the default favicon with a custom one. Instead follow these steps: Go to Shared Components Click Application Definition Attributes (in Application … Continue reading

APEX You Tube Channel

Great idea to organize the Oracle APEX YouTube Channel. David Peake has started a Video Series about the new Page Designer in APEX 5.0. You should have a look.

Our new Oracle APEX YouTube Channel is up and running!

Check out our new Oracle APEX YouTube Channel! Our Product Manager David Peake has started a Video Series about the new Page Designer in Oracle Application Express 5.0. It’s a great start to get familiarized with the new IDE to edit … Continue reading

jQuery Toggle Image

For this, you will need two lines of code.

jQuery – Replace Image

I am posting this just because I am getting questions related to this or similar issues all the time. In this example you can see how you can replace images in your page using Dynamic Actions. There are at least two good ways to do that:

1. Rendering images in a report. Refreshing a report is a predefined event in a Dynamic Action and doesn't require coding.

or

2. Using jQuery to do that.



Enjoy.

Tabular Form – Change Column Type

Just started a new version of My Demo Application - based on APEX 5.0 and Universal Theme. There, I will rework the old content and provide some interesting new possibilities (as of 4.2). In this example I am showing how to change the column type from Text to Display (Saving State) in a tabular form.

APEX 5.0 – PL/SQL Function Returning Error Text – Bug 20971572

I prefer using PL/SQL Function Returning Error Text while creating validations. Two days ago I discovered a bug - it is not possible to create the function if no error message entered. This bug has been documented and will probably be fixed in 5.1. The workaround is to enter a dummy text like "ERROR" or similar.

APEX 5.0 and Standard Report Column

If you are using the new Page Designer in APEX 5.0, you may search for the "Standard Report Column" in the list of column types. If you switch to the component view, you will see it. In the Page Designer you don't have the old column types any more. You should choose "Plain Text" and activate the option "Escape special characters" on the bottom of the column options.

Expert Oracle APEX 2nd Edition

Just submitted first of my two chapters (Tabular Forms) for the new Expert Oracle APEX 2nd Edition. The chapter is covering the most important practices in Tabular Form handling. Also, a couple of neat features like cascading select lists in Tabular Forms - this time using standards only. Still not sure when the book will be published but it should happen soon.

 Follow on Twitter

Enable Real Application Security (RAS) in APEX 5.0

Oracle Database 12c introduced Oracle Real Application Security (RAS), the next generation Oracle Virtual Private Database (VPD). In APEX 5.0 RAS is declaratively build-in. Follow the below steps to enable it:

Login to the INTERNAL workspace and go to Manage Instance > Security:

In the Real Application Security section set Allow Real Application Security to Yes.

Next login to the Workspace your Application is build in and go to your Authentication Scheme.
You'll (more...)

APEX im Jahr 2015

Mit dem erscheinen von APEX 5 dreht die Community jetzt so richtig auf.

Neben der APEX Connect im Juni (bis 08.05. Frühbucherrabatt) wird es schon einen Monat später eine Reihe von APEX 5 Webinaren unter dem Motto #apexsummer15 geben.



Was mir bei den ganzen Aktivitäten auffällt, ist der starke Community Faktor. Umso mehr wundert es mich, dass sich nach Veröffentlichung von APEX 5 keine große IT-News Plattform intensiver mit der Materie befasst (more...)

APEX 5.0 Summer School 2015

Es tut sich ganz schön was in der APEX Community dieses Jahr. APEX 5.0 wurde veröffentlich. APEX Connect im Juni findet statt und sollte bisher der größte APEX-Treffen im deutschprachigen Raum werden. Nun, wurde auch eine Reihe an Webinaren organisiert - APEX 5.0 Summer School - für alle, die keinen Urlaub machen oder für diejenigen, die den Urlaub langweilig finden. Meldet euch an. Die Anzahl der freien Plätze ist nicht unendlich.

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

Destroying The Moon

Just under three years ago, I joined Enkitec when they acquired Sumneva.  The next three years brought a whirlwind of change and excitement - new products, additional training, and expanding the APEX practice from an almost nonexistent state to one of the best in the world.

Like all good things, that run has come to an end.  Last Friday was my final day at Accenture, and I am once again back in the arena of (more...)

Upgrading to Application Express 5.0 in Your Oracle Database Release 12.1 Multitenant Container Database (CDB)

Woo hoo! Oracle Application Express 5.0 has been released. Read all about it here.

The purpose of this blog post is to provide information on how to upgrade your 12.1 Multitenant Container Databases (CDBs) to APEX 5.0, and specifically ones where you have Oracle Application Express installed in CDB$ROOT (the root), and you are making use of Oracle Application Express 4.2.x in the PDBs in this CDB. There has been (more...)