Discussion:
Debug menu items are disabled
Fabio Cosmo
2013-07-24 10:51:09 UTC
Permalink
Hi guys,
i would like to debug a stored procedure but the debug menu presents only
two item enabled: "DBMS Debugger" and "Script debugger". All the others
item, "Set Parameters", "Run", "Run to cursor", "Step over", "Trace into",
"Trace out", "Halt execution", "Set breakpoint", "Add watch at cursor",
"Evaluate/Modify" and "Attach Externale Session" item are disabled.
I attached a jpg to see it.
Why? I have to do a debug.

I installed toad 11.0.0.116 for Oracle and sys user have granted all system
privilegies to my_user:
grant debug connect session to my_user;
grant debug any procedure to my_user;

Thank a lot.
Alan Counihan
2013-07-24 11:11:03 UTC
Permalink
Do your options become available when you click on Script Debugger?
Post by Fabio Cosmo
**
Hi guys,
i would like to debug a stored procedure but the debug menu presents only
two item enabled: "DBMS Debugger" and "Script debugger". All the others
item, "Set Parameters", "Run", "Run to cursor", "Step over", "Trace into",
"Trace out", "Halt execution", "Set breakpoint", "Add watch at cursor",
"Evaluate/Modify" and "Attach Externale Session" item are disabled.
I attached a jpg to see it.
Why? I have to do a debug.
I installed toad 11.0.0.116 for Oracle and sys user have granted all
grant debug connect session to my_user;
grant debug any procedure to my_user;
Thank a lot.
bscalzo
2013-07-24 11:15:06 UTC
Permalink
read this blog:

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/04/10/help-toad-for-oracle-pl-sql-debugger-not-working.aspx
Post by Alan Counihan
Do your options become available when you click on Script Debugger?
Post by Fabio Cosmo
**
Hi guys,
i would like to debug a stored procedure but the debug menu presents only
two item enabled: "DBMS Debugger" and "Script debugger". All the others
item, "Set Parameters", "Run", "Run to cursor", "Step over", "Trace into",
"Trace out", "Halt execution", "Set breakpoint", "Add watch at cursor",
"Evaluate/Modify" and "Attach Externale Session" item are disabled.
I attached a jpg to see it.
Why? I have to do a debug.
I installed toad 11.0.0.116 for Oracle and sys user have granted all
grant debug connect session to my_user;
grant debug any procedure to my_user;
Thank a lot.
bscalzo
2013-07-24 11:17:13 UTC
Permalink
PS - read Mark's blog a few days ago - the Yahoo groups are in the process of being phased out. You need to start using the Toad community forum on toadworld.com.
Post by bscalzo
http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/04/10/help-toad-for-oracle-pl-sql-debugger-not-working.aspx
Post by Alan Counihan
Do your options become available when you click on Script Debugger?
Post by Fabio Cosmo
**
Hi guys,
i would like to debug a stored procedure but the debug menu presents only
two item enabled: "DBMS Debugger" and "Script debugger". All the others
item, "Set Parameters", "Run", "Run to cursor", "Step over", "Trace into",
"Trace out", "Halt execution", "Set breakpoint", "Add watch at cursor",
"Evaluate/Modify" and "Attach Externale Session" item are disabled.
I attached a jpg to see it.
Why? I have to do a debug.
I installed toad 11.0.0.116 for Oracle and sys user have granted all
grant debug connect session to my_user;
grant debug any procedure to my_user;
Thank a lot.
Fabio Cosmo
2013-07-24 12:27:05 UTC
Permalink
The debug connect session privilege was already done, but the debug menu
item, in dbms debugger mode, was disabled.
Post by bscalzo
**
http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/04/10/help-toad-for-oracle-pl-sql-debugger-not-working.aspx
Post by Alan Counihan
Do your options become available when you click on Script Debugger?
Post by Fabio Cosmo
**
Hi guys,
i would like to debug a stored procedure but the debug menu presents
only
Post by Alan Counihan
Post by Fabio Cosmo
two item enabled: "DBMS Debugger" and "Script debugger". All the others
item, "Set Parameters", "Run", "Run to cursor", "Step over", "Trace
into",
Post by Alan Counihan
Post by Fabio Cosmo
"Trace out", "Halt execution", "Set breakpoint", "Add watch at cursor",
"Evaluate/Modify" and "Attach Externale Session" item are disabled.
I attached a jpg to see it.
Why? I have to do a debug.
I installed toad 11.0.0.116 for Oracle and sys user have granted all
grant debug connect session to my_user;
grant debug any procedure to my_user;
Thank a lot.
--
Buona giornata.

Saluti, Fabio Cosmo
Fabio Cosmo
2013-07-24 11:32:08 UTC
Permalink
Some of that item become available when i check on "script debugger"....
Post by Alan Counihan
**
Do your options become available when you click on Script Debugger?
Post by Fabio Cosmo
**
Hi guys,
i would like to debug a stored procedure but the debug menu presents only
two item enabled: "DBMS Debugger" and "Script debugger". All the others
item, "Set Parameters", "Run", "Run to cursor", "Step over", "Trace into",
"Trace out", "Halt execution", "Set breakpoint", "Add watch at cursor",
"Evaluate/Modify" and "Attach Externale Session" item are disabled.
I attached a jpg to see it.
Why? I have to do a debug.
I installed toad 11.0.0.116 for Oracle and sys user have granted all
grant debug connect session to my_user;
grant debug any procedure to my_user;
Thank a lot.
--
Buona giornata.

Saluti, Fabio Cosmo
dennis.paulus@att.net
2013-07-24 12:41:51 UTC
Permalink
As Bert mentioned, please start using the Toad Community on Toad World for future posts.

I couldn't see the attachment, but by chance, is this procedure a part of a package? If so, make sure you are debugging the package body, and not the package spec. Those menu items will be disabled if you are on a package spec.
Loading...