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 Websheet Properties page. To learn more, see "Editing Websheet 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 Websheet Properties page. See "Editing Websheet 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 PL/SQL - Enter a PL/SQL anonymous block of code.

   4. If applicable, select Do not validate PL/SQL code (parse PL/SQL code at run time 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.