This section explains the URL for an Application Express application page, how to use f?p syntax to link pages, and how to call pages using a page alias or button URL.
The URL that displays for each page indicates the location of Oracle Application Express and identifies the address of Oracle Application Express, the application ID, page number, and session ID. For example:
This example indicates:
http: is the scheme.
apex.somewhere.com is the domain name of the server. It can also include a port number or an IP address.
pls is the indicator to use the
mod_plsql cartridge (if applicable)
apex is the Database Access Descriptor (DAD) name. The DAD describes how HTTP Server connects to the database server so that it can fulfill an HTTP request. The default value is
f?p= is a prefix used by Oracle Application Express to route the request to the correct engine process.
4350 is the ID of the application being called. The application ID is a unique number that identifies each application.
1 is the number of the page within the application.
220883407765693447 is the session number. When you run an application, the Application Express engine generates a session number that serves as a key to the user's session state.
You can create links between pages in your application using the following
Table 2-2 describes the arguments you can pass when using
Table 2-2 f?p Syntax Arguments
Indicates an application ID or alphanumeric application alias.
Indicates a page number or alphanumeric page alias.
Identifies a session ID. You can reference a session ID to create hypertext links to other pages that maintain the same session state by passing the session number. You can reference the session ID using the syntax:
Sets the value of
Displays application processing details. Valid values for the DEBUG flag include:
Setting this flag to
You can reference the Debug flag using the following syntax:
See Also: "Debugging an Application"
Clears the cache. This sets the value of items to null.
To clear cached items on a single page, specify the numeric page number. To clear cached items on multiple pages, use a comma-separated list of page numbers. Clearing a page's cache also resets any stateful processes on the page. Individual or comma-separated values can also include collection names to be reset or the keyword
See Also: "Clearing Session State"
Comma-delimited list of item names used to set session state with a URL.
List of item values used to set session state within a URL. To pass a comma in an item value, enclose the characters with backslashes. For example:
Every character sequence except
Determines if the page is being rendered in printer friendly mode. If PrinterFriendly is set to Yes, then the page is rendered in printer friendly mode. The value of PrinterFriendly can be used in rendering conditions to remove elements such as regions from the page to optimize printed output.
You can reference the printer friendly preference by using the following syntax:
When referenced, the page displays using a printer friendly template. The Application Express engine displays all text within HTML form fields as text. The printer friendly template does not need to have the
It is important to understand how
f?p syntax works. App Builder includes many wizards that automatically create these references for you. However, you may have to create the syntax yourself in some situations. The following sections describe specific instances that use
f?p syntax to link pages.
An Application Alias is a unique alternate alphanumeric application identifier that developers can use in place of the application ID. You define an Application Alias editing the Application Definition.
A Page Alias is a unique alternate alphanumeric for a page number. Developers can use a Page Alias in place of the page number ID. You define a Page Alias by editing the page attributes.
Application and page aliases must consist of valid Oracle identifiers, cannot contain any whitespace, and are not case-sensitive. The following example calls a page using an application and a page alias from within an application. It runs the page
home of the application
myapp and uses the current session ID.
Application aliases must be unique within a workspace. If an application in a different workspace has the same application alias, use the
&c argument to specify the workspace name. For example:
"Application Alias" and "Page Alias"
When you create a button, you can specify a URL to redirect to when the user clicks the button. This example runs page 6001 of application 6000 and uses the current session ID.
Note that this is only one approach to using a button. This method bypasses page submission and acts as a hyperlink on the page. You can also have a button click submit a page. In that approach, clicking the button submits the page for processing, allowing forms to be submitted and session state to be saved.
"Creating Buttons" and "APP_SESSION"