Oracle Help for the Web

Execute Procedure/Function

Use this page to specify arguments that will be passed to a procedure or function when you execute it.

If you are executing a procedure, it could display an OracleAS Portal database portlet (for example, SCOTT.EXAMPLE_FORM.SHOW) or perform some other task (for example: SCOTT.GIVE_RAISE). If the procedure, displays an OracleAS Portal database portlet, you will see three arguments defined for the procedure:

P_REQUEST
P_ARG_NAMES
P_ARG_VALUES

See the notes below for an explanation of these arguments.

If the procedure performs a task other than displaying an OracleAS Portal database portlet, the Argument text boxes on this page contain any arguments defined for the procedure. You can click the data type icon next to an argument to obtain additional information about it.

Field Descriptions

Field	Description
Execute	Click to execute the procedure or function with the arguments you specified on this page.
Reset	Click to clear all fields on this page.
Argument data type icon	Displays the argument's datatype. Click the icon to view more information about the argument.
Argument text boxes	Type any argument you want to pass to the function.

Notes

Use a colon (:) to pass multiple elements to an array argument.
Three arguments are typically passed to a procedure that displays an OracleAS Portal database portlet: P_REQUEST, P_ARG_NAMES, P_ARG_VALUES. You can pass one or more argument names in P_ARG_NAMES and one or more argument values in P_ARG_VALUES.
For example, when executing the SCOTT.EXAMPLE_FORM.SHOW procedure, which displays a form based on the SCOTT.EMP table, you could type NAME in P_ARG_NAMES, and CLARK in P_ARG_VALUES. NAME as an argument that corresponding to an entry field on the form. The form that displays would contain CLARK as a default value in the NAME entry field.

Or you could specify DEPTNO:JOB in P_ARG_NAMES, and 10:MANAGER in P_ARG_VALUES to display the following form. Note that manager and Accounting (10) are selected in this form by default.
If you are unsure which arguments are accepted by a procedure that displays an OracleAS Portal database portlet, view the database portlet's call interface. A table displays P_ARG_NAMES and default P_ARG_VALUES defined for the procedure.

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Locating this Page

To locate this page in OracleAS Portal:

On the Portal Builder page, click the Navigator link.
Click the Database Objects tab.
In the Name column, scroll down to the schema whose contents you want to view.
Click the schema's name.
In the Name column, scroll down to the procedure or function you want to execute.
Next to the object, click Execute.