Let us discuss each of these operations individually in the subsequent sections so that you can gain
greater understanding about them.
To step through the program, choose one of the following commands:
Moves to the next executing line in the program being debugged. If the line contains a
program call, will step inside that function, and you could
see the call stack in the stack frame.
Step Into can be performed by clicking on the button present
in PL Debugger's toolbar or pressing
(F-2)
Skips called programs. The program is executed, but the debugger does not step
through its code. Instead, the debugger moves to the next line in the current program after
executing the called program.
Step Over can be performed by clicking on the button present
in PL Debugger's toolbar or pressing
(F-3)
Resumes program execution from the line of code in the green highlight bar.
PL Debugger stops when a breakpoint is encountered or when it reaches the last executable line in
the program.
Continue can be performed by clicking on the button present
in PL Debugger's toolbar or pressing
(F-4)
A breakpoint makes your debugger stop whenever a certain point in the program is reached.
EnterpriseDB PL Debugger allows users to set breakpoints. EnterpriseDB supports two
types of breakpoints, global and local. Global breakpoints are visible to all the users
that access a particular database while the local breakpoints are set locally and are visible
only to the user who has set them. Global breakpoints can be set only by a super user, for example a
DBA. A user has the option to manipulate local and global breakpoints by directly entering
SQL commands using EnterpriseDB PSQL. Both local and global breakpoints can be set on functions,
procedures or triggers.
Breakpoints can be set by the following ways:
Pressing the
(F-5)
shortcut key on a line containing an executable statement.
Clicking on the
button on a line containing an executable statement.
Click the left-hand margin on a line containing an executable statement as shown in the following screenshot:
Once a breakpoint has been set successfully a red circle will appear on the left-hand margin.
You can remove a breakpoint from any of the following ways:
Clicking on the
button on a line containing the breakpoint.
Pressing the shortcut key
(F-6)
on a line containing the breakpoint.
Click the left-hand margin on a line containing a breakpoint.
You can remove all breakpoints in a program in the following two ways: