Thursday, December 18, 2008

A progress bar indicator for Oracle Apex

Always check out the original article at for latest comments, fixes and updates.

One of my favorite mottoes is "do not reinvent the wheel" and this posting shows you how to "recycle" a standard Apex component like a flash chart to display a nicely integrated and animated progress bar, a widget that may come in handy for "entertaining" users during certain long-lasting operations.

So, instead of creating something from scratch, i prefer to re-use an existing and supported component of Apex to achieve the same result, which complies with my initial statement.

The need for a progress bar arose while developing a new page for the recently released DBMS_PROFILER companion application, where i let the user import data from a remote db and owing to the duration of the operation, i wanted to show the current status of the operation occurring in background.

Let me summarize the basic requirements for a successful and meaningful implementation of this widget in your application:
  1. the operation must take several seconds, otherwise why bother?
  2. the process must be executable in background;
  3. user must have the flash player installed but this should not be a problem nowadays.
  4. you must be using Apex 3.1 or newer.
A short full screen video of the apex progress bar indicator is available at the download page linked below or you can click on the image below to see a cropped version.

In order to make the progress bar indicator work in your application, you will need to perform the following actions:
  1. decide whether you want to display the progress bar inside a region of the same page where you execute the process or in a different page;
  2. copy the flash chart region to the desired place;
  3. change the display condition to suit your needs;
  4. create an after submit process that submits your procedure as a background job (an example is provided);
  5. create a page validation based on the code supplied in the demo application (an example is provided);
  6. modify the "core" procedure to make use of the YY_UPD_PROGRESS_BAR procedure (sample procedure YY_TEST_PROGRESS_BAR is provided).
  7. adjust the chart parameters or XML source code to fine tune the progress bar indicator look (optional).
Those interested in a hands-on experience with the progress bar indicator demo can download the auto-installing application from or see a live demo at

See more articles about Oracle Application Express or download tools and utilities.

1 comment:

Omar Sawalhah said...

nice work,
But the download links are broken.


yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles