Users with PL/SQL knowledge can create PL/SQL sections and write their own code against the associated schema.
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:
To add a PL/SQL section:
Enable SQL and PL/SQL on the Websheet Properties page. See "Editing Websheet Properties" in Oracle Application Express Application Builder User's Guide.
Run the Websheet application. See "Running a Websheet".
From the Create menu, select New Section.
You can also select New Section on the Control Panel. See "About the Control Panel".
When prompted for the section type, select PL/SQL and click Next.
Specify the following:
Sequence - Enter the section display sequence.
Title - Enter the section title.
Enter PLSQL - Enter a PL/SQL anonymous block of code.
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.
Click Create Section.
To edit a PL/SQL section:
Run the Websheet as described in "Running a Websheet".
Click the Edit icon that displays in the upper right of the section.
The Edit Section page appears.
Edit the following:
Sequence - Enter the section display sequence.
Title - Enter the section title.
Enter PL/SQL - Enter a PL/SQL anonymous block of code.
To save your changes, click Apply Changes.