I have compiled the sample stored procedure that was given in the toad tutorial for debugging purposes. I used the compile with debug option. Created some watch variables and put some break points.
When I run the procedure from the editor using Execute with Debugger option, the parameter window shows up. I enter the parameter value and hit execute, but the debugger just completes execution without stopping at any of my break points.
Is there a step I am missing ?
Any help will be much appreciated in this regard.
By the way, I am logged in as user SYS and have the all the permissions including the dbms_debug.