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 either:

  • Selecting the Websheet application on the Application home page and right-clicking the Run button. Then, select Copy link address or Copy link location depending on your browser.

  • Running the application and then 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

When users log in, they receive unique session numbers. Do not include the session number as part of the URL.