Breakpoints allow you to suspend execution of a procedural object at a specific location in the SQL code while debugging a database object. If you cannot set a breakpoint at a particular line, no marker appears when you double-click the vertical ruler. Instead, the marker appears at the next possible breakpoint.
To set a breakpoint:
Double-click the vertical ruler at the desired line in SQL Editor. A blue dot appears indicating that the breakpoint has been set and enabled.
Alternatively, right-click the point desired on the vertical ruler and select Toggle Breakpoint.
To remove a breakpoint:
Double-click an existing breakpoint or right-click and select Toggle Breakpoint.
Alternatively, under the Breakpoints tab of Database Debug perspective, select the breakpoint and click the single X button.
To enable or disable a breakpoint:
Move the cursor to the dot on the vertical ruler, right-click and select Enable Breakpoint or Disable Breakpoint. If you are disabling a breakpoint, the blue dot turns into a blank circle on the vertical ruler. Disabling preserves the location of the breakpoint but is passed over during execution.
Alternatively, in the Breakpoints view, select or deselect the check box in front of the breakpoint name. Select enables, deselect disables the breakpoint.
To remove all breakpoints:
In Breakpoints, click the
button.