< Previous | Next >

Running the stored procedure

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:

  1. In the Data Project Explorer view, right-click the stored procedure, and select Run. The Specify Parameter Values window opens.
  2. 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.
  3. 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.
< Previous | Next >