During a debug session, you can have a routine (stored
procedure or function) run until the end of it is reached or until
an active breakpoint is hit.
About this task
To run a procedure, perform one of the following tasks:
- Click the Resume button (
).
- Select Run > Resume from the menu bar.
- Press F8.
Note: If you do not issue a resume or run action for an routine,
the routine might be run to completion automatically. This does not
apply for Java stored procedures.
The run to completion will happen after a set length of inactivity.
This amount of time is set in the debugger preferences. For information
about stored procedure debug preferences, see the related topic.
If
you select Run to Location in the editor,
the stored procedure will run to the selected line unless an active
breakpoint is hit or the end of the stored procedure is reached. You
select the line by moving the cursor to it.
Procedure
To run a stored procedure to a specific line number:
- Make sure the line to run to is visible in the editor by
using the scroll bar or cursor keys to locate the line.
- Run the stored procedure to the line by right-clicking
on the marker bar to the left of the line and selecting Run
To Location from the pop-up menu.
Results
If you run a routine until its end is reached, you can
relaunch the routine by selecting Run > Debug Last
Launched from the menu bar, by pressing F11, or by right-clicking
the debug target in the Debug view and selecting Relaunch from
the pop-up menu..