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"See Also:
"Deleting Page Sections"To add a PL/SQL Section:
Enable SQL and PL/SQL on the Application Properties page. See "Editing Websheet Application Properties".
Run the Websheet application. See "Running a Websheet".
From the Create menu, select New Section.
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.
To add more columns, click Add Column.
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.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.