<< Click to Display Table of Contents >>

Debugging PL/SQL

Top Previous Next

On startup, the PL/SQL Debugger displays the connect dialog. When you press the OK button, two database sessions are established:

The target session runs your PL/SQL code in debugging mode.

The debug session controls the target session.

The session id's can be seen in the status line when you start the Debugger. The image below shows debugging stopped at a breakpoint on Line 21:

Debugger.

 

 

The following debug operations are available:

Debugger_01_trace_into

Trace into

Executes one statement. Traces into procedure calls.

Debugger_00_run

Run

Runs to the end of the invoking block.

Debugger_03_stepover

Step over

Executes one statement. Steps over procedure calls.

Debugger_01_trace_into

Trace out

Runs until the end of the program unit.

Debugger_12_abort

Abort

Aborts execution.

In all cases, program execution will stop at any breakpoint.