The SET_BREAKPOINT function is used to set a breakpoint in a program unit, which remains active for the current session.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Purpose
Note
If the target program reaches the breakpoint, execution will be paused.
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 where the breakpoint is to be set. |
| line# | The line where the breakpoint is to be set. |
| breakpoint# | The unique breakpoint number assigned upon successful completion. |
| fuzzy | Applicable only if the specified line does not contain executable code:
|
| iterations | The number of times to wait before the breakpoint is triggered. Note Only the default value is supported in the current version. |
Return values
| Return value | Description |
|---|---|
| success | The operation was successful. |
| error_illegal_line | A breakpoint cannot be set on this line. |
| error_bad_handle | The program unit does not exist. |