One of your stored procedures contains logical errors, and you want to use Oracle SQL Developer to help you find the cause.
A few different options are available for debugging stored code within Oracle SQL Developer. The environment includes a complete debugger that provides the ability to set breakpoints within the code and modify variable values at runtime to investigate a problem with your code. There are several ways to invoke the debugger for a particular piece of code. When a code object is opened within the editor, the toolbar will contain a red “bug” icon that can be used to invoke the debugger (Figure 12-39).
Figure 12-39. Debugger icon
The right-click contextual menu within the navigator ...