About Publishing the Websheet Application URL

Once you complete your Websheet application, you can publish your production URL.

You can determine the URL to your Websheet application by running the application and copying the URL.

Consider the following example:

http://apex.somewhere.com/pls/apex/ws?p=123:home

Where:

• apex.somewhere.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 Oracle HTTP Server connects to the database server so that it can fulfill an HTTP request. The default value is apex.

• ws?p= is a prefix used by Oracle Application Express to link to a Websheet application.

• 123 is the Websheet application being called.

• home is the home page alias defined as Home Page on the Application Properties page.

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

http://apex.somewhere.com/pls/apex/ws?p=123:home

Tip:

When users log in, they receive unique session numbers. This number displays after :home in the URL. Do not include the session number as part of the URL. When another user tries to run a URL containing a session ID, an error displays.