The INITIALIZE function initializes the target session for debugging.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_DEBUG.INITIALIZE (
debug_session_id IN VARCHAR2 := NULL,
diagnostics IN BINARY_INTEGER := 0)
RETURN VARCHAR2;
Parameters
| Parameter | Description |
|---|---|
| debug_session_id | The ID of the target session. A unique ID is generated if the value of this parameter is NULL. |
| diagnostics | Specifies whether to dump the output of diagnostics to the trace file. Valid values:
|
Note
Only the default value is supported. An error is reported if a non-default value is passed.
Return values
The ID of the newly registered debugging session.
Considerations
The
CREATE ANY PROCEDUREprivilege does not affect the visibility of routines through the debugger. ADEBUGprivilege with a correspondingDEBUG ANY PROCEDUREvariant is introduced for each object. These are required if you want to see routines of users other than the session's logon user.The checks that the debugger makes after this call to look for the DEBUG privilege on individual procedures are performed in the context of the session's logon user, the roles that were enabled on the session level when the call was made, even if those roles were unavailable within a definer's rights environment of the call, and the debug role.