Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Lesson 2: Debug a stored procedure Next Page

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, open the Procedures and Functions folder.

  2. Execute the procedure.

    Right-click the debugger_tutorial procedure and choose Execute from Interactive SQL from the popup menu.

    Interactive SQL opens and the following result set appears:

    top_companytop_value
    (NULL)(NULL)

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

  3. Close Interactive SQL.