Running

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.

To run a procedure, perform one of the following tasks:

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.

To run a stored procedure to a specific line number:

  1. Make sure the line to run to is visible in the editor by using the scroll bar or cursor keys to locate the line.
  2. 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.

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

Related tasks
Using the Debug view
Stepping through a stored procedure
Controlling program execution and working with breakpoints
Using breakpoints
Setting stored procedure debug preferences

Feedback