This probably belongs over in the DB forums. I'm using SQL Developer 20.4 (with included JDK) for Windows, connecting to an Oracle Cloud Autonomous DW that's on 21c. When I try to debug a stored procedure, I get an ORA-01031. When the debugger is set to DBMS_DEBUG, it seems to work . I'm pretty sure I've granted the correct permissions for DBMS_DEBUG_JDWP to work, and updated the ACL. Any thoughts on what could be causing this?
-- As admin
CREATE USER demo IDENTIFIED BY "d3moPassword!";
GRANT CREATE SESSION TO demo ;
GRANT CREATE PROCEDURE TO demo;
GRANT DEBUG CONNECT SESSION TO demo;
GRANT DEBUG ANY PROCEDURE TO demo;
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP to demo;
-- As demo
create or replace procedure p1
as
begin
dbms_output.put_line('Hi!');
end p1;
I set a breakpoint on the one line in the body, compile for debug, and then debug...
Connecting to the database DWDEV - Demo.
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.86.94', '53067' )
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.
Process exited.
Disconnecting from the database DWDEV - Demo.