The SET_BREAKPOINT function sets a breakpoint in a program unit. The breakpoint persists for the current session.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
Note
Execution pauses when the target program reaches the breakpoint.
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
| Parameter | Description |
|---|---|
| program | Information about the program unit in which the breakpoint is to be set. |
| line# | The line at which the breakpoint is to be set. |
| breakpoint# | A unique number by which the breakpoint is referred to after it is set. |
| fuzzy | This parameter is only applicable when the specified line does not contain any executable code:
|
| iterations | The number of times to wait before signaling the breakpoint. Note: In the current version, only the default value is supported. |
Return values
| Value | Description |
|---|---|
| success | The operation was successful. |
| error_illegal_line | Cannot set a breakpoint at the specified line. |
| error_bad_handle | The specified program unit does not exist. |