Oracle Apex - URL

Card Puncher Data Processing


The format of the APEX URL and URL management.




  • pocserver01:7777 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 Oracle 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.
  • 103 is the application id (or the application alias) being called
  • 2 is the page id or page alias to be displayed.
  • 1451367446716618 is the session id.
  • UPDATE is the request
  • Yes is the debug level
  • P2_MDM_SOURCE_SYSTEM_ID,P2_VENDOR_ID are two fields in our form
  • SAP7:DEC-001 are the value of two above fields.

To run this example application, we would use the URL:


When users log in, they receive unique session numbers.



See: apex_util.prepare_url


The REDIRECT_URL Procedure calls owa_util.redirect_url to tell the browser to redirect to a new URL. Afterwards, it automatically calls apex_application.stop_apex_engine to abort further processing of the Application Express application.






Return the server URL where a PL/SQL script is called. (Thanks to bas)

This can only been used in a web server (ie in APEX en not in the database).

function GetApexUrl return varchar2
    return OWA_UTIL.get_cgi_env ('REQUEST_PROTOCOL') || '://'
        || OWA_UTIL.get_cgi_env ('HTTP_HOST')
        || OWA_UTIL.get_cgi_env ('SCRIPT_NAME')      || '/f?p=';

end GetApexUrl;

See: Oracle Apex - OWA (PL/SQL Web Tool Kit)

Documentation / Reference

Discover More
Obiee Apex Integration Example Report Goal
OBIEE - Apex Integration

You may have sometime to change some data in your application. Apex is a great tool that allow you to develop and deploy rapidly a web based application. Here for our example, we must access to a vendor...
Card Puncher Data Processing
Oracle Apex - Debug (Messages)

The debug facility displays application processing details through messages that can be: enabled (to a certain information ) disabled added removed See constant...
Card Puncher Data Processing
Oracle Apex - (Diagnostic|Troubleshooting)

See: Enabling Application Tracing by specifying &p_trace=YES on the URL when displaying a page. The ability to generate a trace file is already controlled if the application has Debug enabled....
Card Puncher Data Processing
Oracle Apex - Application (flows)

An application is an HTML interface that exists on top of database objects such as tables or procedures In the URL, the application number is the first number in the parameter sequence, followed...
Card Puncher Data Processing
Oracle Apex - Custom Authentication

Authentication Function Name: my_authentication PL/SQL Code: REQUESTApex URLPage processing section REQUESTApex URL“”page rendering session id To have proper redirection, the login function...
Card Puncher Data Processing
Oracle Apex - Public Navigation (Page and user)

The public navigation mechanism in Apex. A public navigation means that: the user is a public user (not authenticated), the target page is a public page in the current application This prerequisites...
Oracle Apex Request Expression Condition
Oracle Apex - Request

The request is a system variable initialized: with the name of the button when a user clicks. or with the fourth parameter of the Apex URL It will then start the related process. You can...
Card Puncher Data Processing
Oracle Apex - Session (or application context)

A Session is created after : the authentication of a user the first visit of a public user with the zero session feature Each session is assigned a unique identifier. The Application Express...
Oracle Apex Session State Scope
Oracle Apex - Session state

Session state is a workspace that contains all variables with their values for one user. Session state can be maintained: Per session (to maintain session state per session). The session ID locate...

Share this page:
Follow us:
Task Runner