APEX wizards create them for the delete process in forms, but I thought I'd describe an example of how you might use one for your own needs.
The sole purpose I've used them is to generate HTML text from PL/SQL - often for links to appear near text items. For example, you could use them (more...)
Last week we attended the the 5th annual APEX World event in Zeist. As every year it was very nice to meet the growing APEX community in the Benelux, combined with some excellent APEX international and dutch presentations.
The keynote was given by Joel Kallman about APEX 5.0 followed by 18 very interesting sessions about customer business cases, technical developments and international presentations by APEX specialist from all over the world.
The book follows a different approach than most of the tech books I read (and wrote): Every issue is attacked with a recipe, existing of (more...)
On Tuesday, March 25th the 5th edition of the APEX World event was held by the Dutch Oracle User Group OGh. It has always been the largest APEX only event in the world, but this year it was even bigger. Almost 350 people came to Zeist to listen to a group with some of the most famous names in Application Express.
To see a list of all presentations of this day visit the OGh website. (more...)
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...)
I'll do a separate post for noteable blog posts.
Oracle REST Data ServicesDimitri 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.
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.
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:
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...)