Morgan's Library Oracle DBMS_DEBUG_JDWP_CUSTOM Example Sample Code

Oracle DBMS_DEBUG_JDWP_CUSTOM
Version 11.2.0.2

General Information

Purpose

Default implementation of the custom package procedure that will be invoked to process a debug connection request that arrives in the form of an ORA_DEBUG_JDWP

Source

{ORACLE_HOME}/rdbms/admin/dbmsjdcu.sql

First Available

9.0.#

Dependencies

DBMS_DEBUG_JDWP

Security Model

Execute is granted to PUBLIC

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 must be created for this call to succeed (see links below)

dbms_debug_jdwp.connect_debugger(
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) != '140.142.15.233') THEN
RAISE_APPLICATION_ERROR(-20000, 'debug connection to this host not permitted');
ELSE
dbms_debug_jdwp_custom.connect_debugger(vhost, vport);
END IF;
dbms_debug_jdwp.disconnect;
END;
/

Related Topics
DBMS_DEBUG
DBMS_DEBUG_JDWP
DBMS_NETWORK_ACL_ADMIN
DBMS_NETWORK_ACL_UTILITY

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated: