Setting and removing breakpoints with the routine editor

You can set and remove line breakpoints in the source code of a routine such as a stored procedure or user-defined function.

Before you begin

The routine must be deployed to a database.

About this task

The breakpoint information you set in the routine editor is saved in the workspace. If the routine is moved to a different workspace or is renamed, the breakpoint information is removed from the routine source.

Procedure

To set or remove line breakpoints in a routine:

  1. Open the routine in the routine editor.
  2. Set or remove line breakpoints:
    • To set a line breakpoint, locate the line where you want to add the breakpoint and perform one of the following tasks:
      • Double-click the marker bar to the left of the line where you want to add the breakpoint.
      • Right-click the marker bar to the left of the line and click Add Breakpoint.
    • To remove a line breakpoint, locate the breakpoint that you want to delete in the editor marker bar and perform one of the following tasks:
      • Double-click the breakpoint marker.
      • Right-click the breakpoint marker and click Remove Breakpoint.

Results

The line breakpoint information is saved in the workspace.

Note: If you make changes to source code, you must save the routine and then deploy it again to the database server.

What to do next

When you debug the routine, the debugger displays the breakpoints in both the Breakpoints view and on the marker bar of the editor.


Feedback