Skip Headers
Oracle® Application Express End User's Guide
Release 4.1

Part Number E26811-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

About PL/SQL Sections

Users with PL/SQL knowledge can use PL/SQL sections to write their own code against the associated schema.

Tip:

PL/SQL sections are only available if the Websheet application developer has enabled the Allow SQL and PL/SQL attribute on the Application Properties page. To learn more, see "Editing Websheet Application Properties" in Oracle Application Express Application Builder User's Guide.

Topics:

Adding a PL/SQL Section

To add a PL/SQL section:

  1. Run the Websheet application. See "Running a Websheet".

  2. From the Create menu, select New Section.

    Tip:

    You can also select New Section on the Control Panel. See "About the Control Panel".
  3. When prompted for the section type, select PL/SQL and click Next.

  4. Specify the following:

    1. Sequence - Enter the section display sequence.

    2. Title - Enter the section title.

    3. Enter PLSQL - Enter a PL/SQL anonymous block of code.

    4. If applicable, select Do not validate PL/SQL code (parse PL/SQL code at runtime only). Select this option to create the section even if an errors occurs. Use this option to create the section and then debug it later.

    Tip:

    To view an example, click PL/SQL Example.
  5. Click Create Section.

Editing a PL/SQL Section

To edit a PL/SQL section:

  1. Run the Websheet as described in "Running a Websheet".

  2. Click the Edit icon that displays in the upper right of the section.

    The Edit Section page appears.

  3. Edit the following:

    1. Sequence - Enter the section display sequence.

    2. Title - Enter the section title.

    3. Enter PL/SQL - Enter a PL/SQL anonymous block of code.

  4. To save your changes, click Apply Changes.