A script-enabled browser is required for this page to function properly.

Edit Item Type: Procedures

Skip Navigation Links| Field Descriptions | Related Help Topics | Additional Information | Locating this Page |

Use this page to add procedure calls to an item type to extend its functionality. You can also pass the item type's attributes as parameters to the called procedures.

Go to topField Descriptions

Existing Procedure Calls

Field Description
procedure calls

Displays:

  • The text link that users click to execute the procedure call.
  • The procedure that the item type calls and the parameters to which the item type passes attributes.

Example:

Edit Procedure Delete Procedure Search (http://search.oracle.com? p=& )

Notes:

  • Click Edit Procedure to edit the procedure call. The fields in the Procedure Call Properties section are populated with the properties of the procedure call, where you can edit them.
  • Click Delete Procedure to remove the procedure call from the item type.

Procedure Call Properties

Field Description
Type Choose whether the procedure call is to an HTTP or PL/SQL procedure.
Procedure Call

For HTTP procedures, enter the URL of the procedure, including the protocol used to access it.

For PL/SQL procedures, enter the name of the local procedure. The procedure must already exist in the database and must be prefixed with the name of the schema that owns it.

Examples:

(HTTP) http://search.oracle.com
(PL/SQL) SCOTT.SOME_PROC

Notes:

  • You must enter a value in this field.
  • The PUBLIC user must be explicitly granted execute privileges on the procedure.
Link Text

Enter the text to display as a hypertext link with an item of this type. Users click this link to execute the procedure call.

Notes:

  • You must enter a value in this field.
  • This link text is displayed only if you do not select Display Procedure Results With Item, or if you have not specified an icon.
  • The link is displayed next to an item of this only if the page designer includes the Associated Functions attribute in the region that contains the item.
Icon

Enter the path and file name of an image to associate with this procedure call. Alternatively, click Browse to locate the image. When you click Apply or OK, the file is uploaded to the database.

Example: c:\webart\search.gif

Note: Click Delete to delete the existing image.
Display Procedure Results With Item Select this check box to display the results of the procedure call below an item of this type instead of displaying a link for users to click to execute the procedure.

This is useful if you want the procedure results to be immediately visible to users, rather than requiring them to execute the procedure call themselves by clicking the link.

Pass Attributes As Parameters

Field Description
Attribute Choose an attribute to pass to a parameter in the procedure.

Note: This list includes any additional attributes added to the item type as well as the default attributes.
Pass As Enter the parameter name if it is different from the attribute name.
Add More Click to specify more attributes to pass to parameters in the procedure.

Notes

Go to topRelated Help Topics

Concepts:

Related Page Help:

Go to topAdditional Information

Portal Center:

For more information, go to the Oracle Portal documentation page on the Oracle Technology Network.

Go to topLocating this Page

  1. Log in to OracleAS Portal.
  2. Click the Build tab to bring it forward.
  3. From the Page Groups portlet's Work In drop-down list, select the page group that owns the item type.
  4. In the Content Attribution section, under Item Types, click the name of the item type.
  5. Click the Procedures tab to bring it forward.

Tip: By default, the Page Groups portlet is located on the Build tab of the Portal Builder page.

Copyright © 1994, 2005, Oracle. All rights reserved.