Toad Pocket Reference for Oracle, 2nd Edition

70

|

Toad Pocket Reference for Oracle

Debugger

The Toad for Oracle Professional Edition has an optional

PL/SQL debugging module that provides full debugging

capabilities for stored programs (e.g., procedures, func-

tions, triggers, package procedures, and package functions).

This module lets you do things such as the following:

• Perform line-by-line debugging and error trapping

• Trace into other PL/SQL objects

• Change the values of variables during runtime

• Set breakpoints and watches; with these, you can moni-

tor specific values inside the procedure, function, or

package, as well as the passing/changing of variables

passed to the program

• View the results of a returned REF cursor

This section provides a variety of tips for using the Debugger

with the Procedure Editor. Much more detailed information

is available in the Toad Help files and in the Debugging

chapter in the Toad for Oracle User’s Guide.

TIP

Toad’s Debugger utilizes the Oracle Probe API (v2.0 or

later). Make sure this software is installed and that Ora-

cle’s DBMS_DEBUG package exists under the SYS sche-

ma. Each user requires the EXECUTE privilege on

DBMS_DEBUG. Oracle Database 10g connections also

require the DEBUG CONNECT SESSION privilege.

The Toad Debugger can handle only a single object per tab.

Setting Debugger Options

You can customize the Debugger to suit the way you work.

Debugger options are available from View

➝ Options ➝ Pro-