Oracle | DBMS_DEBUG

Oracle DBMS_DEBUG_JDWP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Connect/disconnect debug using Java Debug Wire Protocol

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
connect_defer_suspension	PLS_INTEGER	1
connect_force_connect	PLS_INTEGER	2
connect_string_environment_var	PLS_INTEGER	1
connect_string_cookie	PLS_INTEGER	2

Dependencies

DBMS_DEBUG_JDWP_CUSTOM

DBMS_ISCHEDFW

DBMS_SQL_MONITOR

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-00022	Attempted to disconnect a session other than self
ORA-01031	User does not have the DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE privileges
ORA-30677	The requested session is already being debugged
ORA-30681	Improper argument was provided for a call to CONNECT_TCP
ORA-30682	Improper value for CONNECT_TCP parameter
ORA-30683	Failed to establish a debugger connection

First Available 9.0

Security Model Owed by SYS with EXECUTE granted to PUBLIC.

Source {ORACLE_HOME}/rdbms/admin/dbmsjdwp.sql

Subprograms

CONNECT_TCP	DISCONNECT	PROCESS_CONNECT_STRING
CURRENT_SESSION_ID	GET_NLS_PARAMETER	SET_NLS_PARAMETER
CURRENT_SESSION_SERIAL

CONNECT_TCP

Connect the specified session to the debugger waiting at host:port

This demo performs added security checks to decide if the debug connection request is granted (for example, by verifying that the debugger is running on a trusted host)

Note: In 11gR1, and thereafter, an ACL or ACE must be created for this call to succeed (see link below) dbms_debug_jdwp.connect_tcp( host IN VARCHAR2, port IN VARCHAR2, session_id IN PLS_INTEGER := NULL, session_serial IN PLS_INTEGER := NULL, debug_role IN VARCHAR2 := NULL, debug_role_pwd IN VARCHAR2 := NULL, option_flags IN PLS_INTEGER := 0, extensions_cmd_set IN PLS_INTEGER := 128);

DECLARE

       vhost VARCHAR2(40) := 'bigdog.mlib.org';

       vport VARCHAR2(10) := '1521';

      BEGIN

        IF (utl_inaddr.get_host_address(vhost) != '119.168.1.119') THEN

          RAISE_APPLICATION_ERROR(-20000, 'debug connection to this host not permitted');

        ELSE

          dbms_debug_jdwp.connect_tcp(vhost, vport);

        END IF;

        dbms_debug_jdwp.disconnect;

      END;

      /

CURRENT_SESSION_ID

Returns the current session identifier dbms_debug_jdwp.current_session_id RETURN PLS_INTEGER;

SELECT dbms_debug_jdwp.current_session_id;

      

       CURRENT_SESSION_ID

      -------------------

                      299

CURRENT_SESSION_SERIAL

Returns the current session serial number dbms_debug_jdwp.current_session_serial RETURN PLS_INTEGER;

SELECT dbms_debug_jdwp.current_session_serial;

      

       CURRENT_SESSION_SERIAL

      -----------------------

                        45345

DISCONNECT

A session cannot yet disconnect another session from a debugger; it can only connect or disconnect itself dbms_debug_jdwp.disconnect( session_id IN PLS_INTEGER := NULL, session_serial IN PLS_INTEGER := NULL);

See CONNECT_TCP Demo Above

GET_NLS_PARAMETER

Sets the value of the specified NLS parameter affecting the format in which NUMBER, DATE, TIME (WITH TIME ZONE) and TIMESTAMP (WITH TIME ZONE) dbms_debug_jdwp.get_nls_parameter(name IN VARCHAR2) RETURN VARCHAR2;

desc nls_session_parameters

      

      SELECT * FROM nls_session_parameters;

      

      SELECT dbms_debug_jdwp.get_nls_parameter('NLS_TIMESTAMP_FORMAT');

      

      
      DBMS_DEBUG_JDWP.GET_NLS_PARAMETER('NLS_TIMESTAMP_FORMAT

      -------------------------------------------------------

      DD-MON-RR HH:MI:SSXFF AM

      

      exec dbms_debug_jdwp.set_nls_parameter('NLS_TIMESTAMP_FORMAT','DD-MON-YYYY HH.MI.SSXFF AM');

      

      PL/SQL procedure successfully completed.

      

      SELECT dbms_debug_jdwp.get_nls_parameter('NLS_TIMESTAMP_FORMAT');

      

      
      DBMS_DEBUG_JDWP.GET_NLS_PARAMETER('NLS_TIMESTAMP_FORMAT

      -------------------------------------------------------

      DD-MON-YYYY HH:MI:SSXFF AM

PROCESS_CONNECT_STRING

Allows a session to connect to a debugger through the use of either the ORA_DEBUG_JDWP operating system environment variable when running an OCI program, or a web browser "cookie" called OWA_DEBUG_<dad> set when running an application through the PL/SQL Web Gateway dbms_debug_jdwp.process_connect_string( connect_string IN VARCHAR2, connect_string_type IN PLS_INTEGER);

TBD

SET_NLS_PARAMETER

Sets the value of the specified NLS parameter affecting the format in which NUMBER, DATE, TIME (WITH TIME ZONE) and TIMESTAMP (WITH TIME ZONE) dbms_debug_jdwp.set_nls_parameter( name IN VARCHAR2, value IN VARCHAR2);

See GET_NLS_PARAMETER Demo Above