The Debug menu or some of its options are disabled.
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
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:
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 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;
For Oracle version 7.3.4.1 with at least Oracle Probe API 2.0
To get your Oracle Probe API version run:
DECLARE
PROBE_MAJOR_VER VARCHAR2(10);
PROBE_MINOR_VER VARCHAR2(10);
BEGIN
DBMS_DEBUG.PROBE_VERSION(PROBE_MAJOR_VER, PROBE_MINOR_VER);
DBMS_OUTPUT.PUT_LINE(MAJOR=||PROBE_MAJOR_VER);
DBMS_OUTPUT.PUT_LINE(MINOR=||PROBE_MINOR_VER);
END;
