Running a procedure during a debug session

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:

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:

  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.

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


Feedback