This function returns the URL to the Application Express instance, depending on the option passed.
Syntax
APEX_UTIL.HOST_URL ( p_option IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
Parameters
Table 34-64 HOST_URL Parameters
Parameter | Description |
---|---|
|
Specifies the parts of the URL to include. Possible values for p_option include:
|
Example
The following example demonstrates how to use the HOST_URL function to return the URL, including the script name, to the current Application Express instance.
declare l_host_url varchar2(4000); l_url varchar2(4000); l_application varchar2(30) := 'f?p=100:1'; l_email_body varchar2(32000); begin l_host_url := apex_util.host_url('SCRIPT'); l_url := l_host_url||l_application; l_email_body := 'The URL to the application is: '||l_url; end;
Parent topic: APEX_UTIL