Run the debugger_tutorial procedure

The debugger_tutorial procedure should return a result set consisting of the top company and the value of products they have ordered. As a result of a bug, it does not return this result set. In this lesson, you run the stored procedure.

To run the debugger_tutorial stored procedure

  1. In the left pane of Sybase Central, double-click Procedures & Functions.

  2. Right-click Debugger_Tutorial (GROUPO) and choose Execute From Interactive SQL.

    Interactive SQL opens and the following result set appears:

    top_company top_value
    (NULL) (NULL)

    This is an incorrect result. The remainder of the tutorial diagnoses the error that produced this result.

  3. Close Interactive SQL.