The service was not stopped altogether however one could see an abnormal sluggishness when opening a page.
This is one of those situations where one may want display some highly visible warning across all pages of an application, in order to inform the users as to why the service quality is below the average standard.
Another good reason for displaying such messages is for announcing server downtime, software upgrades or other important information with minimal effort and especially without tampering with Apex regions on production sites.
One could take this approach even for displaying commercial ADs, including a banner based on an image or a flash clip.
In Oracle Application Express, the basic mechanism for displaying this kind of messages is through the so-called Global Notification Message, an application definition attribute that is substituted to the #GLOBAL_NOTIFICATION# template string at page rendering time.
The global notification message as it is, has a few limitations, that i recap below in sparse order:
- It's monolingual; in order to make it multilingual, one must write all the translations one after each other.
- One must update the message by editing the application definition which isn't easily available in Run Only mode, because the application is not listed in the applications panel.
- If you have more than one applications in the same workspace, you must update the message in each and every application separately.
- There is no built-in mechanism for checking if the templates you are using are able to display the global notification message.
apex_application.g_global_notification := 'some text';
Building on this simple idea, i developed an application that allows you to edit, translate and publish global notifications on all applications belonging to your workspace.
You can freely download this application from the link below:
Yocoya Global Notifications Manager for Oracle Application Express 3.0
(version 1.0 in zip format)
Anyone who dares to try it out?
Not sure yet?
Check out this video that shows you how to be up and running in less than 5 minutes.