CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_DEBUG_JDWP_CUSTOM

Version 11.1
 
General
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 link 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.psoug.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_custom.connect_debugger(vhost, vport);
  END IF;
  dbms_debug_jdwp.disconnect;
END;
/
 
Related Topics
DBMS_DEBUG_JDWP
DBMS_NETWORK_ACL_ADMIN
DBMS_NETWORK_ACL_UTILITY
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [93 users online]    © 2010 psoug.org