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 Data Output 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 D11. D11
is the ID for a department (EMPLOYEE.WORKDEPT) in the EMPLOYEE database. When
you enter this value, the stored procedure will return rows that match this
department ID.
- Click OK.
Messages that show the status of the run are displayed in the Data
Output view. Result sets are displayed on the Results page. You can see several
rows of data that are displayed on the Results tab. These results show D11
in the WORKDEPT column.