sqldeveloper debug issue
grant create session,create procedure to mzlwjf;
grant debug connect session to mzlwjf;
grant debug any procedure to mzlwjf;
grant execute on DBMS_DEBUG_JDWP to mzlwjf;
begin
dbms_network_acl_admin.append_host_ace
(host=>'MABESIYEDT',
ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') ,
principal_name=>'mzlwjf',
principal_type=>sys.XS_ACL.PTYPE_DB) );
end;
/
PL/SQL procedure successfully completed.
conn mzlwjf/mzlwjf
Connected.
mzlwjf@ORA12C> create or replace procedure p as
2 begin
3 dbms_output.put_line('Hello_World');
4 end;
5 /
Procedure created
mzlwjf@ORA12C> alter procedure p compile debug ;
Procedure altered.
mzlwjf@ORA12C>