During a debug session, you can have a stored procedure 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 SQL stored procedure,
it will run to completion automatically (this applies to SQL stored procedures,
and not Java™ stored procedures). This 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 stored procedure until its end is reached, you can
relaunch the stored procedure 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..