Creating a PL/SQL folder

Related topics

When adding a folder to a content area, you must first choose a distinct folder type before specifying the folder attributes. The PL/SQL folder type allows you to enter PL/SQL code which generates HTML when the folder is rendered as well as gives you complete control over the display of database stored information.

You must be logged on as the content area administrator or higher. After the folder is created, you can grant folder owner privileges to any other user or group.

To create a PL/SQL folder:

Note: If you are in the folder area in which you want to create a folder and are in Edit mode, click Create Folder from the folder dashboard. Continue from step 3 below.

In the Navigator, click the Content Areas tab.

Navigate to the appropriate path:

Create

Path

Action

Parent Folder (level 1)

Path: Content Areas > Name of Content Area

Next to the Folders container, in the Actions column, click Create to display the Folder Wizard.

Sub-folder (level 2)

Path: Content Areas > Name of Content Area > Folders

Next to the appropriate sub-folder, in the Actions column, click Create to display the Folder Wizard.

Note: If you do not see the folder that you want to work with, this means that you have not been granted the appropriate folder access privileges. See your content area administrator to request folder access.

From the Folder Type list, select PL/SQL.

Click Next.

In the PL/SQL Code field, enter (or paste) the PL/SQL code you want to be executed when the folder is accessed.

Note: You do not need to include the BEGIN and END statements, but you must include the final semicolon (;).

In the Name field, enter a name to be used internally.

Notes:

The Name must be unique within the content area, and is limited to 60 characters. The name can contain only alphanumeric characters (A-Z, a-z, 0-9) and the underscore (_) character. Do not use spaces or other special characters.

If you are using direct access URLs to access folders, do not edit the Name as this change's the object's path and may cause your path link to break.

In the Display Name field, enter a name (limited to 256 characters) for the folder's link text which appears on the Navigator and throughout the product.

Choose the category to which the folder belongs. A folder must belong to a category, and can belong to only one category.

Choose the database schema that executes this PL/SQL folder. The PL/SQL Execute Options secure the PL/SQL code so that it is executed or parsed by a selected database schema.

Select the database schema that executes this PL/SQL item:

Schema

Description

Public

Executed by a public database schema.

Creator

Executed by the database schema mapped to the creator of this folder.

Schema

Executed by any valid database system schema.

Note: This option is available only if the logged on user has DBA privileges.

Click Finish.

The Navigator appears with your newly-created folder reflected below the Name column.

Notes

Although, Oracle Portal lets you create as many folder levels as you want, try to keep the number of sub-folders to a minimum to avoid having to click several levels to reach your destination folder.

To customize the folder properties, see Editing a folder.

You can also extend these folder types by creating folder attributes to permit search and group by functionality across multiple types of content, store additional information about folders or to pass information to procedures. See Adding attributes to a folder type.

For a listing of all folders in a given content area, click the Folder link from the Content Area Administration page or Content Area Map.

If you are creating a sub-folder (a folder nested in a parent folder) that you want to make public to all users of the content area, make sure that the parent folder is also displayed to public users. Otherwise, the parent folder won't be displayed and the sub-folder will be moved to the top of the hierarchy in the Content Area Map. This can be confusing for end users.

If you want a navigation bar to display with a folder, you can assign a navigation bar.

You can choose another page to apply to the content area. The page controls the portlets you want displayed in the page regions.

Related topics
When adding a folder to a content area, you must first choose a distinct folder type before specifying the folder attributes. The PL/SQL folder type allows you to enter PL/SQL code which generates HTML when the folder is rendered as well as gives you complete control over the display of database stored information.
	You must be logged on as the content area administrator or higher. After the folder is created, you can grant folder owner privileges to any other user or group.

Related Topics
What is a folder? What are folder types? Creating a custom folder type Adding a folder to your interest list What is a folder owner? Applying a style to a folder	Editing a folder Assigning a folder owner Cascading all folder privileges Creating a style Revoking style privileges from folder owners Creating a personal folder