Sometimes you may want to call an APEX webpage from within an Oracle Form. For example, when you want to redirect the user to another system which is built in APEX. Or the user wants to show a report which was already created in APEX – there's no need to create it twice and by the way, calling an Oracle Report is basically the same as calling an APEX webpage. With the Form's built-in web.show_document
, it is possible to call a webpage from within a Form. We will make use of this function to demonstrate how to call an APEX report (an overview of customers with a Google map) from an Oracle Form.
Make sure you have a running Forms environment. Open an existing form from where you want to call an APEX webpage.
Have a look at your APEX URL. You can find it in the upper region of your browser and it looks like this:
The
URL starts with the hostname followed by the port number. The host and the port number are separated by a colon. After apex/
you can...