Creating a PL/SQL page

Related topics

PL/SQL pages display the results of executing a piece of PL/SQL code. PL/SQL pages allow you to include data from your database in your page group.

To create a page, you must have at least one of the following privileges:

• Portal administrator

• Manage All privileges on the page group in which you want to create the page

• Manage global privileges on All Pages

• Create global privileges on All Pages and Manage privileges on the parent page of the new page

To create a PL/SQL page:

1. In the Navigator, click Contents next to the page group in which you want to create the page.

2. Click Create in the Pages row.

   Tip: If you want to create the page as a sub-page of another page, click Create next to the page under which you want to create the new PL/SQL page.

3. In the Page Type list, choose PL/SQL.

   Note: If PL/SQL is not included in this list, the PL/SQL page type has been excluded from the page group.

4. In the Name field, enter a name for the page.

   Note: The name is used internally and for direct access URLs. The name is limited to 40 characters, and can contain any alphanumeric character (A-Z, a-z, 0-9), spaces, and the following special characters: _, -, ., (, ), ! , ; = ~ @.

5. In the Display Name field, enter a descriptive name for the page.

   Note: The display name is limited to 40 characters.

6. (Optional) In the Description field, enter a description for the page. The description is displayed only when you edit the page. It does not appear to the user.

   Note: The description must not exceed 2000 characters.

7. Click Next.

8. In the PL/SQL Code field, enter (or paste) the PL/SQL code you want to execute when the page is displayed.

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

9. Select:

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

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

   • Schema to execute the PL/SQL code as a specific database schema. Enter the database schema name, or click and select a schema from the list provided. This option is available only if you have DBA privileges.

10. Click Next.

11. (Optional) Select Display Page To Public Users if you want everyone, including users who are not logged into the portal, to be able to view the page.

12. (Optional) To explicitly grant privileges to specific users or groups:

    1. In the Grantee field, enter the name of the user or group that you want to allow to access this page.

       Tip: If you are not sure of the name of the user or group, click (for users) or (for groups), and select from the list provided.

    2. In the list, choose a privilege level.

       Notes:

       • The order of the privileges in the list is not based on any hierarchy of privileges. For more information, see Page privileges.

       • The following page privileges do not apply to PL/SQL pages: Manage Items With Approval, Manage Style, Customize Portlets, Customization

    3. Click Add.

       Tip: If you want to grant a user or group multiple privileges, for example Manage Content and Manage Style, add the user or group separately for each privilege.

13. Click Finish to create the page and return to the Navigator.

Notes

• Because Oracle Internet Directory (OID) can include multiple directory containers that use the same group names, the distinguished name (DN) is displayed next to any group that does not belong to the local Portal instance.

Related Topics

What are page types?
Editing page properties

Back to top