GRANT debug any procedure, debug connect session TO 用户
--执行 PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '172.18.204.53', '56695' ) ORA-24247:
--网络访问被访问控制列表 (ACL) 拒绝
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE
(
host => '172.18.204.53', --指定host
lower_port => null,
upper_port => null,
ace => xs$ace_type(privilege_list => xs$name_list('jdwp'),
principal_name => 'LY_QZK', --指定user
principal_type => xs_acl.ptype_db)
);
END;
PL/sql 记得添加调试信息 才能进断点