The APEX_PAGE
package is the public API for handling pages.
The following constants are used by this package.
c_ui_type_desktop constant varchar2(10) := 'DESKTOP'; c_ui_type_jqm_smartphone constant varchar2(15) := 'JQM_SMARTPHONE';
This function returns TRUE if the current page has been designed for desktop browsers.
FUNCTION IS_DESKTOP_UI RETURN BOOLEAN;
This function returns TRUE if the current page has been designed for smartphone devices using jQuery Mobile.
FUNCTION IS_JQM_SMARTPHONE_UI RETURN BOOLEAN;
This function returns TRUE if the current page has been designed for tablet devices using jQuery Mobile.
FUNCTION IS_JQM_TABLET_UI RETURN BOOLEAN;
This function returns the user interface (UI) type for which the current page has been designed.
FUNCTION GET_UI_TYPE RETURN VARCHAR2;
This function returns TRUE if the current page is rendered read-only and FALSE if it is not.
FUNCTION IS_READ_ONLY RETURN BOOLEAN;
This function returns the page mode for the current page.
FUNCTION GET_PAGE_MODE ( p_application_id IN NUMBER, p_page_id RETURN VARCHAR2;
This procedure purges the cache of the specified application, page, and region for the specified user. If the user is not specified, the procedure purges all cached versions of the page.
PROCEDURE PURGE_CACHE ( p_application_id IN NUMBER DEFAULT wwv_flow.g_flow_id, p_page_id IN NUMBER DEFAULT wwv_flow.g_flow_step_id, p_user_name IN VARCHAR2 DEFAULT NULL, p_current_session_only IN BOOLEAN DEFAULT FALSE );
Table 19-2 PURGE_CACHE Parameters
Parameter | Description |
---|---|
|
|
|
|
|
Specify a user name if you only want to purge entries that were saved for the given user. |
|
Specify TRUE if you only want to purge entries that where saved for the current session. Defaults to FALSE. |
This example purges session specific cache on the current page.
BEGIN APEX_PAGE.PURGE_CACHE ( p_current_session_only => true ); END;
This function returns an Oracle Application Express f?p= URL
. It is sometimes clearer to read a function call than a concatenated URL. See the example below for a comparison.
FUNCTION GET_URL ( p_application IN VARCHAR2 DEFAULT NULL, p_page IN VARCHAR2 DEFAULT NULL, p_session IN NUMBER DEFAULT WWV_FLOW.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 ) RETURN VARCHAR2;
Parameter | Description |
---|---|
|
The application ID or alias. Defaults to the current application. |
|
Page ID or alias. Defaults to the current page. |
|
Session ID. Defaults to the current session ID. |
|
URL request parameter. |
|
URL debug parameter. Defaults to the current debug mode. |
|
URL clear cache parameter. |
|
Comma-delimited list of item names to set session state. |
|
Comma-delimited list of item values to set session state. |
|
URL printer friendly parameter. Defaults to the current request's printer friendly mode. |
|
SQL trace parameter. |
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