Defining Stored Procedure
|
|
|
This page can be used to define a stored procedure.
Select the “Define Stored ” link under the “Help On Stored Procedure” page.
The “Define Stored Procedure” page appears.
Note: The system launches the page with a sub title, which can be either “Stored Procedure for Process Rule” or “Stored Procedure for Resource Rule” based on the activity/task being performed.
The “Process Rule” task evaluates the success or failure
of the rule whereas the “Resource Rule” task is for user identification.
The system displays the following:
|
Component Name |
The name of the component based on the previous task. |
|
Activity Name |
The name of the activity based on the previous task. |
|
Task Name |
The name of the task based on the previous task. |
Enter the following fields:
|
Stored Procedure Name |
The name of the stored procedure (Alphanumeric, 25). |
|
Stored Procedure Description |
The description of the stored procedure (Alphanumeric, 40). |
Click the “Get” pushbutton to retrieve the stored procedure details.
Modify the rule code in the “Rule” text box, if required.
The system displays the following fields in “Parameters” multiline:
|
Parameter |
The name of the predefined parameter associated with the stored procedure. |
|
Flow Direction |
The direction of the flow of parameter value. This can be either “Input” or “Output” based on the parameter. |
|
Data Type |
The predefined data type of the parameter. |
|
Length |
The length of the parameter. |
Click the “Compile” pushbutton to build the rule and compile the stored procedure in the database.
Click the “Delete” pushbutton to drop the existing stored procedure from the database.
Note: For both Compiling and Deleting purposes, the RVW user must have DB Owner permissions.
You can specify the stored procedure name and description and create rules.
Use the “Define Stored Procedure” page to create a Stored Procedure.