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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Stored procedures and triggers » Debugging procedures, functions, triggers, and events » Tutorial: Getting started with the debugger » Lesson 2: Debug a stored procedure

 

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.