-
Debugging a Package procedure, even after commenting out the “commit” statement in the Anonymous block generated for debugging, it still commits. i.e. that leaves me no chance of checking the result before commiting or rolling back. This is rather dangerous on the production box.
-
Setting a break point on the package procedure and then invoke the procedure from the Editor will not break. I have to create a stored procedure to call the package procedure in order for the break to take affect.
-
Often time can’t set the break point and have to restart Toad. Sometimes need to re-boot. There is a serious memory leak.
-
Often time can’t even start the debugging session because the anonymous block was not get generated. Only the dialog is present but not code generated.