Is it possible to debug an anonymous procedure without creating an object?
Anonymous block can't be dubugged into since Oracle treats them as a single statement In order to debug, Oracle has to make a number of DBMS system calls and it cannot do that to an object that's not compiled into the database. So, an anonymous block needs to be an object compiled into the database before it can be debugged.
To debug code that is in an anonymous block, write it as a procedure and debug as a procedure with DBMS debugger in Toad.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center