PL/SQL Same Page Redirect Script
While working with Oracle PL/SQL web applications, I have encountered a case where a feature for click on the button link will send some email notification. A successful email sent will hide the send button in the original page; if not, the send button will still be shown. I was thinking of using some Oracle’s PL/SQL built-in commands for use like owa_util.redirect_url. There are cases when built-in commands does not do the job as expected.
Finding a solution is to go back to HTML basics with the use of the “script” tag and its “location” attribute. I find the following solution to redirect a PL/SQL page back to it.
htp.p(‘<script>
location = “http://www.techxplore.net/finance.fr001″;
</script>’);
It’s pretty simple and straight forward. It worked well with my PL/SQL web application in hiding the send letter button after sending an email successfully.
Posted on
Sunday, August 30th, 2009 at 12:03 pm under 