The Debug menu or some of its options are disabled. I cannot debug my PL/SQL procedure, packages, etc. code.
1. Oracle user account does not have the required Oracle rights to debug an object.
2. Upgrading from 9i to 10g but the 10g rights for the debugger are not granted.
3. Prior to Toad 9.6.0, the debugger was not part of the standard package
4. In 12.9 and above, the Toad Option - Execute/Compile | 'Treat blank line as terminator' is parsing the procedure/package incorrectly and being flagged as having syntax errors. This in turn disables any debugging functionality, since Toad thinks the procedure is invalid.
RESOLUTION 1:
If using Toad versions 9.5 and prior, ensure that the Toad license key includes the Debugger option by going to Help | Support Bundle.
To register Toad with a License Key that includes the Debugger module:
1. Select Help | Register Toad menu option.
2. Enter the appropriate License Key and Site Message. The Site Message is both case and space sensitive.
RESOLUTION 2:
Upgrade to the current version of Toad, which includes the Debug module with all license keys. The latest version of Toad can be downloaded at:http://support.quest.com/support_download/Downloads.asp
RESOLUTION 3:
1. Go to the Debug Menu and make sure DBMS Debugger is checked
2. Make sure the Green Bug Icon in the Toolbar is depressed
RESOLUTION 4:
Verify that a script is open in the editor. If working with packages, make sure to be in the body, as debug options differ when in the spec vs the body.
RESOLUTION 5:
In Toad 9.0 and above, you go to Help | Toad Advisor. Under Alerts it will display a note Debugger privileges missing if the Oracle login does not meet the minimum requirements for debugging. Ensure user account has all the required Oracle privileges granted for debugging objects on that database.
The following privileges are required for debugger:
1. GRANT ALTER SESSION TO user_name;
2. GRANT CREATE SESSION TO user_name;
3. GRANT EXECUTE ON DBMS_DEBUG to user_name;
Minimum requirements to debug other than your own procedures, functions, and packages:
1. GRANT ALTER ANY PROCEDURE TO user_name; (compile)
2. GRANT CREATE ANY PROCEDURE TO user_name; (edit / save)
The following additional privileges are required for debugger in Oracle Database version 10g (IN ADDITION TO THE ABOVE) and any version released after that:
1. GRANT DEBUG ANY PROCEDURE TO user_name;
2. GRANT DEBUG CONNECT SESSION TO user_name;