SET_BREAKPOINT Function

This function sets a breakpoint in a program unit, which persists for the current session. Execution pauses if the target program reaches the breakpoint.

Syntax

DBMS_DEBUG.SET_BREAKPOINT (
   program     IN  program_info,
   line#       IN  BINARY_INTEGER,
   breakpoint# OUT BINARY_INTEGER,
   fuzzy       IN  BINARY_INTEGER := 0,
   iterations  IN  BINARY_INTEGER := 0)
  RETURN BINARY_INTEGER;

Parameters

Table 9-17 SET_BREAKPOINT Function Parameters

Parameter	Description
program	Information about the program unit in which the breakpoint is to be set. (In version 2.1 and later, the namespace, name, owner, and dblink may be set to NULL, in which case the breakpoint is placed in the currently-running program unit.)
line#	Line at which the breakpoint is to be set.
breakpoint#	On successful completion, contains the unique breakpoint number by which to refer to the breakpoint.
fuzzy	Only applicable if there is no executable code at the specified line: 0 means return error_illegal_line. 1 means search forward for an adjacent line at which to place the breakpoint. -1 means search backwards for an adjacent line at which to place the breakpoint.
iterations	Number of times to wait before signalling this breakpoint.

Note: The fuzzy and iterations parameters are not yet implemented.

Returns

Table 9-18 SET_BREAKPOINT Function Returns

Return	Description
success
error_illegal_line	Cannot set a breakpoint at that line.
error_bad_handle	No such program unit exists.