6.5 Creating a PL/SQL Page

PL/SQL pages display the results of executed PL/SQL code. PL/SQL pages provide one of the ways you can include data from your database in your page group. In Oracle Portal, you have the added benefit of security features offered through the portal's access settings.


To create a page, you must have at least the page privilege Manage on the new page's parent page.

To create a PL/SQL page:

  1. Log in to Oracle Portal.

  2. Click the Build tab to bring it forward.

  3. From the Page Groups portlet Work In drop-down list, select a page group to own the PL/SQL page.

    By default, the Page Groups portlet is located on the Build tab of the Portal Builder page.

  4. In the Layout & Appearance section, click the Create link next to the Pages heading.

    If the page is a sub-page of an existing page (rather than of the page group's root page), follow the steps outlined in Section 6.3, "Creating a Sub-Page". Then return to Step 5 in this section.

  5. On the resulting page, select PL/SQL from the Page Type list.

    If PL/SQL is not included in this list, the PL/SQL page type has been excluded from the page group. If you have the required privilege, you can click the Configure link next to the Page Type list, and configure the page group to include this type. Otherwise, ask the Page Group administrator to include the type.


    For more information on configuring a page group, see Chapter 4, "Working with Page Groups"
  6. In the Display Name field, enter a Display Name for the page.

    Use up to 256 characters of any kind. The Display Name identifies the page in the Page Groups portlet and the Portal Navigator.


    In the Oracle Portal user interface, an asterisk (*) indicates a field that requires a value.
  7. In the PL/SQL Code field, enter (or paste) the PL/SQL code to execute when the page is displayed.

    You do not need to include BEGIN and END statements, but you must include the final semicolon (;).


    The PL/SQL code you enter here is not validated. Validation is performed when an attempt is made to execute the code. If the code is good, it executes when the page is rendered. If the code is invalid, error messages are returned. Once you create the page, be sure to test the code.
  8. In the PL/SQL Execute Options section, select either:

    • Public to execute the PL/SQL code as the PUBLIC database schema.

    • Creator to execute the PL/SQL code as the database schema that is mapped to your user account.

    • Schema to execute the PL/SQL code as a specific database schema. Enter the database schema name, or click the Browse icon and select a schema from the list provided. This option is available only to users with the global privilege Manage on the object type All Schemas.

  9. Click Create to create the page.

  10. After you have created your page you may want to either create another page or edit the properties of the newly created page to add more detail.


    For information on editing page properties, see Section 6.9, "Editing Page Properties.".