I am not able to debug PL/SQL and i have following error please advice how I can enable privileges and I want to know the steps of debugging.
Connecting to the database My_connection.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP
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.
Disconnecting from the database My_connection.
Thanks for your time
You need to get the DBA for the database to grant your account the privileges mentioned in the error message.
Once that is done it should just work.
Make sure you compile for debug
You need some way to stop the debugger from just running through the code to the end
- either set breakpoints
- or Use Tools|Preferences|Debugger|Start Debugging Option to Step Into.