The INITIALIZE function is used to initialize the target session for debugging.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this.
Syntax
DBMS_DEBUG.INITIALIZE (
debug_session_id IN VARCHAR2 := NULL,
diagnostics IN BINARY_INTEGER := 0)
RETURN VARCHAR2;
Parameters
| Parameter | Description |
|---|---|
| debug_session_id | The name of the session ID. If this parameter is NULL, a unique ID is generated. |
| diagnostics | Indicates whether to dump diagnostic output to the trace file:
|
Note
Only default parameters are supported. An error will be returned if a non-default parameter is specified.
Return value
The debug session ID (DebugID) of the newly registered debugging session.
Considerations
The
CREATE ANY PROCEDUREprivilege does not affect the visibility of routines through the debugger. ADEBUGprivilege has been introduced for each object, along with the correspondingDEBUG ANY PROCEDUREvariable, which can be used to view routines owned by users other than the logged-in session user.After this call, the debugger will check the debugging permissions for individual procedures based on the login user of the session, including the roles enabled at the session level during this call (even if these roles are not available in the caller's privilege environment), as well as the debugging role.