New Oracle@Oracle paper shows how GoldenGate allowed for real-time operational reporting for Oracle E-Business Suite: http://t.co/SQVfHcD7
04
February
2010
Understanding the URL and how to Pass Parameters
Understanding the URL that Displays for a Page
Using f?p Syntax to Link Pages
f?p=1:2:3:4:5:6:7:8:9
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:
http://apex.oracle.com/pls/apex/f?p=4350:1:220883407765693447This example indicates:
- apex.oracle.com is the URL of the server
- pls is the indicator to use the mod_plsql cartridge
- 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 apex.
- f?p= is a prefix used by Oracle Application Express
- 4350 is the application being called
- 1 is the page within the application to be displayed
- 220883407765693447 is the session number
Using f?p Syntax to Link Pages
You can create links between pages in your application using the following syntax:
f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendlyf?p=1:2:3:4:5:6:7:8:9
The following describes the arguments you can pass when using f?p syntax.
| Syntax | Description | |
|---|---|---|
|
1 |
App |
Indicates an application ID or alphanumeric alias. |
|
2 |
Page |
Indicates a page number or alphanumeric alias. |
|
3 |
Session |
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:
|
|
4 |
Request |
Sets the value of REQUEST. Each application button sets the value of REQUEST to the name of the button. This enables accept processing to reference the name of the button when a user clicks it. You can reference REQUEST using the syntax:
|
|
5 |
Debug |
Displays application processing details. Valid values for the DEBUG flag are YES or NO. Setting this flag to YES displays details about application processing. You can reference the Debug flag using the following syntax:
|
|
6 |
ClearCache |
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 RP, which resets region pagination on the requested page. The keyword APP clears cache for all pages and all application-level items in the current application and removes sort preferences for the current user. The keyword SESSION achieves the same result as the APP keyword, but clears items associated with all applications that have been used in the current session.
|
|
7 |
itemNames |
Comma-delimited list of item names used to set session state with a URL. |
|
8 |
itemValues |
List of item values used to set session state within a URL. Item values cannot include colons, but can contain commas if enclosed with backslashes. To pass a comma in an item value, enclose the characters with backslashes. For example: \123,45\ |
|
9 |
PrinterFriendly |
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: V('PRINTER_FRIENDLY')
When referenced, the Application Express engine will not display tabs or navigation bars, and all items will be displayed as text and not as form elements. |