How to use the Toad Debugger?

I am currently evaluating the Toad for Oracle 10.5 Trial, but I can’t seem to get the debugger to work.

When I open up a PL/SQL package, procedure or function, the only options that are enabled under the Debug menu are:

  • Add Watch at Cursor
  • DBMS Debugger
  • JDWP Debugger
  • Script Debugger

All the other options such as “Run to Cursor”, “Trace Into”, “Set Breakpoint” are disabled.

Is there any way to enable these? I’ve tried searching through the forums and Knowledge Base, but to no avail.

This may help…

Check or grant debug priv to the schema/user…

grant DEBUG CONNECT SESSION to _____;