One of my clients reported an issue – they were seeing ”Waiting for 184.108.40.206″ and a blank screen when they tried to access the Apex web site I’d built for them. They were using Mozilla on a Windows PC, connecting via Vodaphone 3G – the problem was consistent, and it went away when they used their ADSL connection.
My initial response was “don’t use Vodaphone 3G” because the problem seemed to be outside of (more...)
During my time off I noted a bunch of information to dig into later, and I thought I'd make some notes as I go - see if you missed any interesting news.
I'll do a separate post for noteable blog posts.
Oracle REST Data Services
As Dimitri announced here
, Oracle has another product "formerly known as" - this time it's the APEX Listener.
Now known by what I think is a name that may also (more...)
A few weeks ago Packt Publishing asked me if I would give a book review for the recently released Oracle APEX Cookbook, the second edition by Marcel van der Plas and Michel van Zoest. In exchange I would get the e-book for free, so this can be considered a sponsored blogpost. Even though it is sponsored I will give my honest opinion about it.
The book contains fifteen chapters starting with "Creating a Basic APEX (more...)
Instead of calling a function, when you can get the same effect by accessing a documented PL/SQL variable, you should. For example:
v('APP_USER') = APEX_APPLICATION.g_user
v('REQUEST') = APEX_APPLICATION.g_request
v('APP_ID') = APEX_APPLICATION.g_flow_id
v('APP_PAGE_ID') = APEX_APPLICATION.g_flow_step_id
v('DEBUG') = APEX_APPLICATION.g_debug
g_debug is a boolean, unlike the
There’s more here: documentation for the APEX_APPLICATION package
I suspect that the implementation of
v() is something like this:
FUNCTION v (p_name IN (more...)
I decided to try using a wrapper procedure to isolate calls to APEX_UTIL.set_session_state in an autonomous transaction. I’m currently using it in a project and seeing how it goes in terms of performance.
DISCLAIMER: Don’t just throw this into your mission-critical system without at least testing it thoroughly first.
Since I had Morten Braten’s Alexandria library handy, I simply modified his APEX_UTIL_PKG. If you’re not using this library you can create your own wrapper (more...)
When should you commit or rollback a transaction? As late as possible, I would have thought, based on most of the advice in the Oracle world. You certainly want this to be predictable and consistent, at least.
Unfortunately, if you use
APEX_UTIL.set_session_state in your PL/SQL process, the result is not so predictable.
Thanks to Martin D’Souza who alerted me to this. I love learning new things, but occasionally you get a bad surprise like (more...)
As part of our effort to mobilize Oracle Forms customers, last week we did a new spin on things by presenting running Oracle Forms from APEX mobile. The webinar, presented with the APEX rockstar Roel Hartman, was a huge success! We had over a 184 people register and were pleased to see such positive responses from viewers.
APEX Evangelist and Oracle ACE Director, Roel Hartman shared his experience developing a modernized APEX application on an (more...)
I recently saw this approach used in a complex Apex application built for my current client, and I liked what I saw – so I used a similar one in another project of mine, with good results.
- Pages load and process faster
- Less PL/SQL compilation at runtime
- Code is more maintainable and reusable
- Database object dependency analysis is much more reliable
- Apex application export files are smaller – faster to deploy
- Apex pages can be (more...)
Like all of us, I have had the pleasure to take a look at APEX 5.0 EA1. One of the most anticipated features was build-in support for modal dialogs. In this blog we will examine this feature more closely.
An easy way to investigate this feature is by creating two simple pages: report & form using the wizard.
Follow the wizard and base the report & form on the demo_customer table. When you come (more...)
On one of the pages there was a need to refresh a report region when a node in an APEX Tree was clicked. As far as I know there is no built-in method to create a Dynamic Action to a node in an APEX Tree, so this might call for a Custom Event.
If there is a built-in method, please leave a comment :)
Trigger Custom Event
To trigger a Custom Event, change the "link" (more...)
This year, from June 22 - June 26, the best convention in the world, ODTUG’s KScope14 will be held in Seattle, Washington. I am already looking forward to meeting some ‘old’ friends again, creating new friends and seeing some of the best content by presenters from all over the world.
Some of the presentations I am looking forward to:
In the Developer’s Toolkit track:
If you are working with Oracle software as a developer, DBA or application server administrator, you should read the new OTech Magazine.
The Winter 2014 issue is almost a book: 136 pages of high-quality technology articles by some of the leading experts in their respective fields. My contribution is the article “From Requirements to Tool Choice” about how to choose the right Oracle development tools (ADF, APEX, or Forms).
And did I mention it (more...)
The long awaited Early Adopter installation is finally available at http://apexea.oracle.com. You can request a workspace here to play around with the new version. I have just been playing around with it for about an hour an from what I’ve seen it’s a big change to what we’re used to since APEX 4.
Not only has the look an feel changed to flat , but I think the biggest visible change is (more...)
This morning (for us on CET) brought a surprise from the developers over at Oracle Application Epress headquarters. The Early Adopters release for APEX 5.0 has been made available to the public.
On https://apexea.oracle.com you can request access to the environment. After approval you can start testing all the new features for the upcoming version of APEX.
There are many things to discover, but the most obvious one is the new Grid (more...)
Get it? “an item with many hats”… yeah ok.
Need to change the label of an item on-the-fly? When I run my Apex page it renders item labels like this:
If the label needs to change based on another item, I could set the label with the value of another item, e.g. “&P1_CONTACT_NUMBER_LABEL.” and when the page is refreshed it would pick up the new label. But at (more...)
For those of us who have been developing in APEX for a while will understand that the value of an item in APEX is not always what it seems. That’s right; an item has two values in APEX. The first value is the session value that we can store in the database (server side), the second value is the value the end user sees on his screen in the browser (client side). On some occasions (more...)
Take the The Evolution of Oracle Forms Survey Now.
I can hardly believe it but its been over 2 years since we did our original Oracle Forms modernization poll for developers. Boy time flies when your having fun! Now we are once again joining with Oracle and the Oracle Forms Community to conduct the “Evolution of Oracle Forms” customer survey. We are doing this survey to really try and determine what are the needs of (more...)
One of the demands for a customer application built in Oracle Application Express was, that a part of the application could be completely operated by the numpad of a keyboard. This had to do with the physical aspects of one of the workstations. There was simply not enough room for a full keyboard.
When building an APEX application, you have several tools to your disposal to allow this. First of all there is the option (more...)
My current client has a large number of Apex applications, one of which is a doozy. It is a mission-critical and complex application in Apex 4.0.2 used throughout the business, with an impressively long list of features, with an equally impressively long list of enhancement requests in the queue.
They always have a number of projects on the go with it, and they wanted us to develop two major revisions to it in (more...)