12-12. Debugging Stored Code

Problem

One of your stored procedures contains logical errors, and you want to use Oracle SQL Developer to help you find the cause.

Solution

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 ...

Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.