Database Administration (MOSC)

MOSC Banner

sqldeveloper debug issue

edited Nov 11, 2017 4:04AM in Database Administration (MOSC) 5 commentsAnswered

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>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center