Adding procedure calls to a custom item type

You can add procedure calls to custom item types and pass attributes as parameters to those called procedures. For information about adding attributes to a custom item type, see Adding attributes to a custom item type.

You must be the content area administrator, the portal administrator, or have Manage privileges on All Content Areas to add procedure calls to a custom item type.

To add procedure calls to a custom item type:

  1. In the Navigator, click the Content Areas tab.

  2. Navigate to the following path:

    Path: Content Areas > ContentAreaDisplayName > Custom Types > Item Types

    where ContentAreaDisplayName is the content area in which the custom item type was created.

    Note: If the custom item type is shared, it will be in the Shared Objects content area.

  3. In the row for the custom item type that you want to edit, click Edit.

  4. Click the Procedures tab.

  5. In the Type list, choose whether the procedure call is to an HTTP or PL/SQL procedure.

  6. In the Procedure Call field, enter one of the following:

    • The URL of the HTTP procedure, including the protocol used to access it, for example http://search.healthyliving.com.

    • The name of the PL/SQL procedure, for example SCOTT.SOME_PROC. The procedure must already exist in the database and must be prefixed with its owning schema.

  7. In the Link Text field, enter the text to display as a hypertext link with an item of this type. Users click this link to execute the procedure call.

    Note: This link is displayed only if you do not select Display Procedure Results With Item, or you have not specified an icon.

  8. (Optional) In the Icon field, enter the path and file name of an image to associated with this procedure call. This icon is displayed instead of the value entered in the Link Text field.

    Click Browse to locate the image if you are not sure of its path or file name.

    Note: If you specify an icon, you must still enter a value in the Link Text field.

  9. (Optional) Select Display Procedure Results With Item to display the results of the procedure call directly in the folder area with 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.

  10. If the procedure being called has parameters, you can pass attributes to those parameters.

    1. In the Attribute list, choose the attribute to pass to the parameter in the procedure.

      Note: This list includes any additional attributes added to the custom item type as well as the default attributes.

    2. In the Pass As field, enter the parameter name if it is different from the attribute name.

  11. Click Apply to add the procedure call to the custom item type and display it in the Existing Procedure Calls section.

  12. To add more procedure calls, repeat Steps 5 through 11.

  13. Click OK.

Notes

  • You cannot add procedure calls to base item types.

  • To delete a procedure call from a custom item type, click ed-del.gif next to the procedure call in the Existing Procedure Calls section. To edit an existing procedure call, click next to the procedure call in the Existing Procedure Calls section. You can then edit the procedure call properties in the Procedure Call Properties section, and click Apply to save your changes.

  • If the custom item type is based on the Java Application item type, a call to a Java Base Procedure is added by default. You cannot delete this procedure call, and you cannot edit its Procedure Call field.

Related topics

Creating a custom item type
Changing a custom item type's basic properties
Adding attributes to a custom item type

Deleting a custom item type
What is an item?