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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » The SQL Anywhere debugger » Variables

 

Displaying the call stack

You can examine the sequence of calls that has been made when you are debugging nested procedures. You can view a listing of the procedures on the Call Stack tab.

Prérequis

You must have the SA_DEBUG system role.

Additionally, you must have the EXECUTE ANY PROCEDURE system privilege or EXECUTE privilege on the procedure.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click Mode » Debug.

  3. In the Which User Would You Like To Debug field, type * to debug all users, or type the name of the database user you want to debug.

  4. In the left pane, double-click Procedures & Functions and select a procedure.

  5. In the right pane, click the line where you want to insert the breakpoint.

    A cursor appears in the line where you clicked.

  6. Press F9.

    A red circle appears to the left of the line of code.

  7. In the Debugger Details pane, click the Local tab.

  8. In the left pane, right-click the procedure and click Execute From Interactive SQL.

  9. In the Debugger Details pane, click the Call Stack tab.

Résultat

The names of the procedures appear on the Calls Stack tab. The current procedure is shown at the top of the list. The procedure that called it is immediately below.