Sql Developer Debug not work
I am using oracle10g and i am using sql developer as client , I want to debug my procedure and I am using the run menu but it produce the following error pls help me to resolve the issue.
Connecting to the database SCOTT.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '124.125.202.74', '4000' )
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 SCOTT.
Connecting to the database SCOTT.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '124.125.202.74', '4000' )
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 SCOTT.
closed account (o3hC5Di1)
Hi there,
This would better be asked on a forum related to oracle, but this bit here:
Is telling you that the user under which you are connecting to the database does not have the rights (privileges) to do DEBUG stuff.
Change the user's privileges if you have access to them and try again.
Hope that helps,
All the best,
NwN
This would better be asked on a forum related to oracle, but this bit here:
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. |
Is telling you that the user under which you are connecting to the database does not have the rights (privileges) to do DEBUG stuff.
Change the user's privileges if you have access to them and try again.
Hope that helps,
All the best,
NwN
Last edited on
Topic archived. No new replies allowed.