Breakpoints

Breakpoints are temporary markers that you place in your code to tell the debugger to stop your routine at a given point and can be set in all types of routines supported by the debugger, including stored procedures and functions, as well as PL/SQL package stored procedures and routines.

When you are debugging routines, you can set line breakpoints and variable breakpoints. Both breakpoint types are saved upon termination of a debug session.

When the workbench is running a routine and encounters a breakpoint, the routine temporarily stops running. Execution suspends at the breakpoint before the statement is executed, at which point you can check or edit the contents of variables. You can then step over (execute) and see what the effect of the statement is.

With the debugger, setting breakpoints is easily accomplished by way of pop-up menus in the debugger editor and Variables view. Once set, you can disable breakpoints so they do not suspend execution and then, later, enable them again.


Feedback