I have a debug license and all required privileges to debug a procedure. However, the debug menu is still grey out when I try to debug a procedure.
Please load a procedure into the Procedure Editor window, then go to the "Session" menu and select the PL/SQL Debugging option.
The following privileges are needed to use the Debug feature:
GRANT ALTER ANY PROCEDURE TO user_name
GRANT CREATE ANY PROCEDURE TO user_name
GRANT ALTER SESSION TO user_name
GRANT CREATE SESSION TO user_name
GRANT EXECUTE ON DBMS_DEBUG to public
With Oracle 10g, you need these additional privileges:
GRANT DEBUG ANY PROCEDURE TO user_name
GRANT DEBUG CONNECT SESSION TO user_name