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"

Topics:

• Adding a PL/SQL Section

• Editing a PL/SQL Section

See Also:

"Deleting Page Sections"

Adding a PL/SQL Section

To add a PL/SQL Section:

1. Enable SQL and PL/SQL on the Application Properties page. See "Editing Websheet Application Properties".

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.

      To add more columns, click Add Column.

   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.

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