Calling APEX from an Oracle Form

Sometimes you may want to call an APEX web page 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—no need to create it twice and by the way, calling an Oracle Report basically goes the same as calling an APEX web page. With the Form's built-in web.show_document it is possible to call a web page from within a Form. We will make use of this function to demonstrate how to call an APEX report (overview of customers with a Google map) from an Oracle Form.

Getting ready

Make sure you have a running Forms environment. Open an existing Form from where you want to call an APEX web page.

Have a look at your APEX URL. You can find it in the upper region of your browser and it looks like the following:

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...