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)
IS
tmpvar NUMBER;
tmpvar2 NUMBER;
total NUMBER;
BEGIN
tmpvar := 0;
tmpvar2 := 0;
total := 0;
FOR lcv IN 1 .. inval
LOOP
total := 2 * total + 1 - tmpvar2;
tmpvar2 := tmpvar;
tmpvar := total;
END LOOP;
DBMS_OUTPUT.put_line (TOTAL IS: || total);
END loopproc;
/
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy