You can run the stored procedure for testing purposes.
When you run the stored procedure, you can determine whether the run
is successful and whether the result set exists. You can also test
the logic of the routine and the accuracy of output arguments and
result sets. When you run a stored procedure from the workbench, the
workbench calls the stored procedure, and the results are displayed
in the SQL Results view.
To run the stored procedure:
- In the Data Project Explorer view, right-click the stored
procedure, and select Run. The
Specify Parameter Values window opens.
- In the Value field, type 018. 018 is the ID for an organization (EMP_EMPLOYEE_DIM.ORGANIZATION_CODE)
in the EMP_EMPLOYEE_DIM table. When you enter this value, the stored
procedure will return rows that match this organization ID.
- Click OK.
Messages that show the status of the run are displayed in
the SQL Results view. Result sets are displayed on the Result page.
You can see several rows of data that are displayed on the Result
page. These results show 018 in the ORGANIZATION_CODE column.