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:
- Open the routine in the routine editor.
- 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.