7.1.4 Main Debugger Window
• the Program Body pane
• the Stack pane
• the Output paneYou can use the debugger menu bar or tool bar icons (located at the top of the debugger window) to access debugging functions.22.214.171.124 The Program Body PaneThe Program Body pane in the upper-left corner of the Debugger window displays the source code of the program that is being debugged.Figure 7.5 shows that the Debugger is about to execute the SELECT statement. The green indicator in the program body highlights the next statement to execute.126.96.36.199 The Stack PaneThe Stack pane displays a list of programs that are currently on the call stack (programs that have been invoked but which have not yet completed). When a program is called, the name of the program is added to the top of the list displayed in the Stack pane; when the program ends, its name is removed from the list.Reviewing the call stack can help you trace the course of execution through a series of nested programs.Figure 7.6 shows that emp_query_caller is about to call a subprogram named emp_query. emp_query_caller is currently at the top of the call stack.After the call to emp_query executes, emp_query is displayed at the top of the Stack pane, and its code is displayed in the Program Body frame (see Figure 7.7).Upon completion of execution of the subprogram, control returns to the calling program (public.emp_query_caller), now displayed at the top of the Stack pane in Figure 7.8.Highlight an entry in the call stack to review detailed information about the selected entry on the tabs in the Output pane. Using the call stack to navigate to another entry in the call stack will not alter the line that is currently executing.188.8.131.52 The Output PaneYou can use tabs in the Output pane (see Figure 7.9) to view or modify parameter values or local variables, or to view messages generated by RAISE INFO and function results.
• The Parameters tab displays the current parameter values.
• The Local Variables tab displays the value of any variables declared within the program.
• The DBMS Messages tab displays any results returned by the program as it executes.
• The Results tab displays program results (if applicable).184.108.40.206 The Status BarThe status bar (see Figure 7.10) displays a message when the Debugger pauses, when a runtime error message is encountered, or when execution completes.