Adding procedure calls to a custom page type

Related topics

You can add procedure calls to page types and pass attributes as parameters to those called procedures. For an example of a custom type procedure, see Adding procedure calls to a custom item type.

For information about adding attributes to a custom page type, see Adding attributes to a custom page type.

Note: You must be the page group administrator, the portal administrator, or have Manage privileges on All Page Groups to add procedure calls to a page type.

To add procedure calls to a page type:

1. In the Navigator, click the Page Groups tab.

2. Navigate to the following path:

   Path: Page Groups > PageGroupDisplayName > Custom Types > Page Types

   where PageGroupDisplayName is the page group in which the custom page type was created.

   Note: If the custom page type is shared, it will be in the Shared Objects page group.

3. In the row for the custom page 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.oracle.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.

     Note: The PUBLIC user must be granted execute privileges on the procedure.

7. In the Link Text field, enter the text to display as a hypertext link in the main banner of a page 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 Page, or you have not specified an icon.

8. (Optional) In the Icon field, enter the path and file name of an image to associate 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 Page to display the results of the procedure call directly in a page 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. (Optional) 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 page 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 page 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

• To display the procedure link or results, the page designer must add a Page Function item to the the page when he or she creates a page of this type.

• You cannot add procedure calls to base page types.

• To delete a procedure call from a custom page type, click 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.

Related topics

What are page types?
Creating a custom page type
Changing a custom page type's basic properties
Adding attributes to a custom page type
Deleting a custom page type
Choosing the page types available in a page group

Back to top