The Trace into option is not working for the debugger. The Package keeps on failing with call stacks stating �??Process is not accessible".
On the other hand, for testing purposes the following Procedure works with the Trace Into option:
CREATE OR REPLACE PROCEDURE loopproc (inval NUMBER)
tmpvar := 0;
tmpvar2 := 0;
total := 0;
FOR lcv IN 1 .. inval
total := 2 * total + 1 - tmpvar2;
tmpvar2 := tmpvar;
tmpvar := total;
DBMS_OUTPUT.put_line (TOTAL IS: || total);
1) Ensure the schema has the minimum Debug privileges.
2) Select View | Toad Options | Data Grid | Debugger | uncheck "break on exceptions"
3) Run the SQL Monitor utility against the Package to analyze the background queries.
4) Ensure the Package does not have any necessary lines of code commented out.