Adding a PL/SQL item

Related topics

Using the Item Wizard, choose the PL/SQL item type to add a PL/SQL content item. When the item is added to the folder area, end users can click the item's link to execute the PL/SQL procedure and display the results. Or, the PL/SQL code can display directly in the folder area if you chose "Item Displayed Directly In Folder Area" as the Display Option.

You must be logged on as a folder owner or an authorized user with the appropriate folder or item-level privileges.

To add a PL/SQL item to a specific folder:

Note: If you are already in the folder in which you want to add an item, skip to step 4.

  1. In the Navigator, click the Content Areas tab to navigate to Path: Content Areas.

  2. In the Name column, click the content area link that contains the item you want to work with.

  3. The content area home page (root folder) is displayed with all the sub-folder links that were chosen.

    • If necessary, click a sub-folder link to view the contents of a given folder.

    • 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 gain access.

  4. Click Edit folder located on the main banner to switch to Edit mode.

  5. From the folder dashboard, click Add Item to display the Item Wizard.

  6. From the Item Type list, choose PL/SQL.

  7. Click Next.

  8. In the Folder Region field, click the radio button next to the name of the folder region where you want this file item to appear.

  9. In the PL/SQL Code field, enter the PL/SQL code that executes when this item is clicked.

  10. In the Display Name field, enter the item's link text. This is what users will click to view the item.

  11. Choose a category that best describes what this item is (its content) and enter a description for this item.

  12. In the Publish Date field, enter the exact date on which this item is displayed to public users.

Note: If you are the item or folder owner or were granted the Manage Items privilege, this item is immediately accessible in Edit mode.

  1. In the Expiration Period field, choose whether you want this item to be always available, available only for a specified number of days (calculated from the publish date), or if it expires on a specific date (DD-MON-YYYY).

  2. In the PL/SQL Execute Options field, choose the database schema in which you want to execute this PL/SQL item: the Public schema or the schema belonging to the item's creator.

  3. Click Next.

  4. Perspectives describe the audience or interest area for the item. In the Perspectives field, click the appropriate move arrow to move a perspective from the Available Perspectives to the Displayed Perspectives list. Use the appropriate up and down arrows to determine the order that the perspectives are displayed next to the item.

Notes:

  • Unlike categories, you can choose more than one perspective for an item. For example, a sales report might belong to both the Sales Representative and Marketing Manager perspectives.

  • You can select multiple perspectives by holding the Ctrl key while clicking each perspective you want.

  • Hover over the arrows for hint text.

  1. Enter or browse to the location of the image file that you want to associate with this item and then select how the image is aligned in the folder area.

  2. Enter a keyword used to locate this item in a basic search and enter a name for the author.

Note: By default, the Author field is filled with the name of the initial logged on user.

  1. Select the appropriate check boxes to enable document control or hide the item in View mode.

  2. In the Display Options field, choose how you want the PL/SQL item to display in the folder area:

    • Link That Displays Item In Folder Area

    • Item Displayed Directly In Folder Area

    • Link That Displays Item In Full Browser Window

    • Link That Displays Item In New Browser Window

  3. Click Finish to save your changes and return to the folder area.

Notes

  • Item attributes such as Author, Description, Expiration Date, Image, New Item Indicator, and so on are displayed in the folder area only if they were chosen to display. For more information, see Choosing item attributes to display in a folder region.

  • A PL/SQL item is executed as the user who created the item. Therefore, only the user who created a PL/SQL item may edit the item. Even folder owners or users with the Manage Items privilege may not edit PL/SQL items that they did not create.

  • When adding or editing an item, if the Display Name field is left blank, the link text that appears is "View."

Related Topics

What is an item?
What are item types?
Adding an item
Editing an item

Displaying an item property sheet
Creating a PL/SQL folder
Java stored procedure example

Back to top