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

E35124-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
PDF · Mobi · ePub

2.12 About PL/SQL Sections

Users with PL/SQL knowledge can create PL/SQL sections and 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 Websheet Properties page. To learn more, see "Editing Websheet Properties" in Oracle Application Express Application Builder User's Guide.

Topics:

2.12.1 Adding a PL/SQL Section

To add a PL/SQL section:

  1. Enable SQL and PL/SQL on the Websheet Properties page. See "Editing Websheet Properties" in Oracle Application Express Application Builder User's Guide.

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

  3. From the Create menu, select New Section.

    Tip:

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

  5. 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 when an error occurs. Use this option to create the section and then debug it later.

    Tip:

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

2.12.2 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.