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:
Now lets take a look at what those scripts are doing:
With d0. (more...)
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...)
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...)
Hi everyone and happy “new” year!
This year’s resolution is to do even more APEX. Is this possible, you might ask?
Sure, for example on Feb 19 2015 at our next orclapex Vienna Meetup.
Hope to see you there. Patrick and Christian will provide us with the latest news of APEX 5 and tell us more about Early Adopter #3.
Don’t waste any more time: RSVP yes.
As preparation for my Presentation about Worst Practices in Oracle APEX I set up a survey using the Survey Builder Packaged Application.
Please help out and fill in the survey: https://apex.oracle.com/pls/apex/f?p=80076:Q::AAAW
There will be a follow up post with details on worst practices and survey results.
Thanks for your time,
For a long while now I’m having this idea to initiate an APEX group on some social network to bring APEX Fans together and have regular meetings in my hometown Vienna, Austria.
This idea in mind I met Dan McGhan at APEX World 2014 in Zeist, Netherlands. While talking about this and that we discovered that we both are fans of meetup.com which is a platform to organize meeting groups.
Of course we instantly (more...)
Suddenly a big thunder rolled through the APEX community -> Version 5.0 has arrived in an early adopter version, as published on Joel Kallmans Blog (as usual on a friday, late night over here in europe).
Over the past 10-15 month we saw numerous presentations of what we can expect in APEX 5, and many of us had our own ideas.
As soon as I got word through twitter I applied for a workspace (more...)
In the first two parts of this blogpost series we covered the basics and the technique on how to provide nice/friendly/readable URLs for a public APEX Application.
If you haven’t read the other two parts, please go back and read part 1, then read part 2. Done? Ok, lets continue.
Again here the links for two examples: the Sample Database Application which will be used as example in this post and the click-click Website (more...)
In the first part of this Blogpost Series we touched some fundamentals and finally listed some options. If you haven’t read it, yet, please do now before continuing here.
The last post ended with me saying I found a way for hrURLs that works with APEX Listener, mod_plsql and EPG.
I haven’t tested the Thoth Gateway, but based on the documentation I’d say it works as well as the mod_plsql way.
Just to be (more...)
Searching the APEX Forum for nice URLs is as old as Oracle APEX itself, so far without much luck. There is magic switch that forces APEX to create readable URLs.
As part of preparing my Presentation “Going Public” for Kscope 2014 in Seattle, I investigated the available methods on providing readable URLs and found some good ones.
You can check this public APEX website to see how good URLs can look like: www.click-click. (more...)