GET_URL Function

This function returns an APEX navigation. It is sometimes clearer to read a function call than a concatenated URL. See the example below for a comparison.

If the specified application is located in a different workspace, the URL does not contain a checksum.

Syntax

APEX_PAGE.GET_URL (
    p_application        IN VARCHAR2 DEFAULT NULL,
    p_page               IN VARCHAR2 DEFAULT NULL,
    p_session            IN NUMBER   DEFAULT APEX.G_INSTANCE,
    p_request            IN VARCHAR2 DEFAULT NULL,
    p_debug              IN VARCHAR2 DEFAULT NULL,
    p_clear_cache        IN VARCHAR2 DEFAULT NULL,
    p_items              IN VARCHAR2 DEFAULT NULL,
    p_values             IN VARCHAR2 DEFAULT NULL,
    p_printer_friendly   IN VARCHAR2 DEFAULT NULL,
    p_trace              IN VARCHAR2 DEFAULT NULL,       
    p_triggering_element IN VARCHAR2 DEFAULT 'this',
    p_plain_url          IN BOOLEAN DEFAULT FALSE )
    RETURN VARCHAR2;

Parameters

Parameter	Description
`p_application`	The application ID or alias. Defaults to the current application.
`p_page`	Page ID or alias. Defaults to the current page.
`p_session`	Session ID. Defaults to the current session ID.
`p_request`	URL request parameter.
`p_debug`	URL debug parameter. Defaults to the current debug mode.
`p_clear_cache`	URL clear cache parameter.
`p_items`	Comma-delimited list of item names to set session state.
`p_values`	Comma-delimited list of item values to set session state.
`p_printer_friendly`	URL printer friendly parameter. Defaults to the current request's printer friendly mode.
`p_trace`	SQL trace parameter.
`p_triggering_element`	A jQuery selector (for example, `#my_button`, where `my_button` is the static ID for a button element), to identify which element to use to trigger the dialog. This is required for Modal Dialog support.
`p_plain_url`	If the page you are calling `APEX_PAGE.GET_URL` from is a modal dialog, specify `p_plain_url` to omit the unnecessary JavaScript code in the generated link. By default, if this function is called from a modal dialog, JavaScript code to close the modal dialog is included in the generated URL.

Example

This query uses APEX_PAGE.GET_URL and its alternative APEX_UTIL.PREPARE_URL to produce two identical URLs.

SELECT APEX_PAGE.GET_URL (
            p_page   => 1,
            p_items  => 'P1_X,P1_Y',
            p_values => 'somevalue,othervalue' ) f_url_1,
         APEX_UTIL.PREPARE_URL('f?p=&APP_ID.:1:&APP_SESSION.::::P1_X,P1_Y:somevalue,othervalue')
     FROM DUAL