INITIALIZE

The INITIALIZE function initializes the target session for debugging.

Syntax

DBMS_DEBUG.INITIALIZE (
   debug_session_id  IN VARCHAR2       := NULL,
   diagnostics       IN BINARY_INTEGER := 0)
  RETURN VARCHAR2;

Parameters

Return values

The ID of the newly registered debugging session.

Usage notes

• The caller or the specified debug role must have the DEBUG CONNECT SESSION privilege

  before their calls to DBMS_DEBUG can succeed, otherwise, an error is reported. Other exceptions are possible if: a debug role is specified but the password is invalid; the caller is not granted the role; or the role is application-enabled but the call does not come from the role-enabling package.

• The CREATE ANY PROCEDURE privilege does not affect the visibility of routines through the debugger. A DEBUG privilege with a corresponding DEBUG ANY PROCEDURE variant is introduced for each object. These are required if you want to see routines of users other than the session's logon user.

• The authentication of the debug role and the check for DEBUG CONNECT SESSION privilege are performed in the context of the caller to this routine. If the caller is a definer's rights routine or is called from one, only privileges granted to the defining user, the debug role, or PUBLIC are used to check for DEBUG CONNECT SESSION. If this call is made from a definer's rights routine, the debug role, if specified, must be the one that is granted to the definer, but it does not need to have been granted to the session logon user or be enabled in the calling session at the time of the call.

• 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.