25.9.3 Creating a Legacy Websheet Application

Create a Websheet application in App Builder by running the Create Application Wizard, or by clicking Create in a running Websheet.

Note:

Creating a Websheet application is disabled by default. To enable Websheet creation, enable WEBSHEET_CREATE_ENABLED instance parameter by using APEX_INSTANCE_ADMIN API.

• Enabling Websheet Creation
  
• Creating a Websheet from App Builder
  
• Creating a Websheet Application from a Running Websheet
  

25.9.3.1 Enabling Websheet Creation

By default, the ability to create Websheet applications is disabled. To enable the creation of Websheet applications by setting the WEBSHEET_CREATE_ENABLED instance parameter to Y using the APEX_INSTANCE_ADMIN package.

This parameter cannot be set from the Oracle Application Express Administration Services (Administration Services), but only using APEX_INSTANCE_ADMIN API.

To enable the creation of Websheet applications:

1. Start SQL*Plus and connect to the database where Oracle Application Express is installed having the apex_administrator_role role or as SYS specifying the SYSDBA role. For example:

   • On Windows:

     SYSTEM_DRIVE:\ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   • On UNIX and Linux:

     $ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   Tip:

   The APEX_ADMINISTRATOR_ROLE must be granted directly to a user and not through another database role.

2. Execute the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_200200;
   
   

3. Execute the following statement:

   BEGIN
   APEX_INSTANCE_ADMIN.SET_PARAMETER('WEBSHEET_CREATE_ENABLED', 'Y' );
   COMMIT;
   END;
   /

The Websheet link appears in the Create Application Wizard.

25.9.3.2 Creating a Websheet from App Builder

To create a Websheet application:

1. On the Workspace home page, click the App Builder icon.
2. Click the Create button.
   The Create Application Wizard appears.
3. Select Websheet and click Next.
4. On Create Websheet:
   1. Websheet - Enter a unique integer value to identify the application. Application IDs between 3000 to 9000 are reserved for internal use.
   2. Name - Enter a unique integer value to identify the application.
   3. Include Getting Started Guide - Select this option to include basic information about using Websheets in the first text section of the Websheet home page. Once reviewed, you can edit or remove this text section.
5. Confirm your selections and click Create Websheet.
   A success message appears.
6. To view a rendered version of your application:
   1. Click Run Websheet.
   2. Enter your Websheet credentials:

      1. Username - Enter your username.

      2. Password - Enter your password.

      3. Click Sign In.

   The Websheet application appears in a new window.

25.9.3.3 Creating a Websheet Application from a Running Websheet

To create a Websheet application from a running Websheet:

1. Run a Websheet application.
2. From the Create menu, click New Websheet.
3. On Create Websheet:
   1. Websheet - Enter a unique integer value to identify the application. Application IDs between 3000 to 9000 are reserved for internal use.
   2. Name - Enter a name to identify the application.
   3. Click Next.
4. Confirm your selections and click Create .
   A success message appears.
5. To view a rendered version of your application:
   1. Click Run Websheet.
   2. Enter your Websheet credentials:

      1. Username - Enter your username.

      2. Password - Enter your password.

      3. Click Sign In.

      The Websheet application appears in a new window.