Table of Contents Previous Next


7 Debugger : 7.1.4 Main Debugger Window

the Program Body pane
the Stack pane
the Output pane
main_debugger
The Program Body pane in the upper-left corner of the Debugger window displays the source code of the program that is being debugged.
program_body
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.
The 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.
call_stack_1
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).
call_stack_2
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.
call_stack_3
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.
You 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.
output_pane
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).
Screen shot 2013-07-25 at 9

7 Debugger : 7.1.4 Main Debugger Window

Table of Contents Previous Next