Oracle APEX 3.1 is here

Written by Paulo Vale on Friday, February 29, 2008

Finaly... the waiting is over :) and now we can integrate the stunning new features in our applications.

Oracle APEX 3.1 is now available to download. Just follow the link: http://www.oracle.com/technology/products/database/application_express/index.html.

And if you've been in the moon in the last weeks please take a look to the new great features.

Navigate to previous page

Written by Paulo Vale on Sunday, February 17, 2008

When developing an application we must provide intuitive navigation. When a user enters a page and it's presented with "Cancel" button, clicking this button should redirect the user to the page he came from. To achieve this, we can create a branch referring a page number. However, fixing a page number isn´t the best solution because the origin page can be variable.

I've tested some solutions using javascript:history.back() or decoding the referrer url using owa_util.get_cgi_env('HTTP_REFERER') among others, but ended with a self made solution. This solution consists in having an PL/SQL application process executed "On Load Before "Body" Region(s)" updating an application item wich stores the last page visited by the user.

So let me elaborate, step by step:

1- Create two application items.

2- Create a PL/SQL application process.

Code:



3- Go to you page and edit the branch linked to the CANCEL or SUBMIT button.


That´s it. Please feel free to comment or add an alternative solution.