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.

To display the call stack

1. Connect to the database as a user with DBA authority.

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

3. Select a procedure.

4. Choose 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 choose Execute From Interactive SQL.

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

    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.