Displaying the call stack

It is useful to 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.

Prerequisites

DBA authority.

Context and remarks

Many.

 Display the call stack

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. In the left pane, double-click Procedures & Functions.

  3. Select a procedure.

  4. Click Mode » Debug.

  5. 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.

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

    A cursor appears in the line where you clicked.

  7. Press F9.

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

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

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

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

Results

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.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1