Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
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
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,
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(15) := '1521';
BEGIN
IF (utl_inaddr.get_host_address(vhost) != vport) 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;
/
*
ORA-29257: host bigdog.mlib.org unknown