Hi
I need debugging anonymous blocks in Toad fo Oracle 12.8
In Debug Menu I enabled SCRIPT DEBUGGER but debug finished immediately.
Suggestions?
Thanks in advance
Stephen
An anonymous block looks like this:
DECLARE
...
BEGIN
...
END;
/
Change it to this:
CREATE OR REPLACE PROCEDURE anonymous_block AS
...
BEGIN
...
END;
/
ALTER PROCEDURE anonymous_block COMPILE DEBUG;
Now you may set breakpoints in the procedure and debug it like any other procedure, function or package. When done, drop the procedure or change the first line to DECLARE.
The reason you’re seeing that behavior is that an anonymous block is technically just a single statement (at least in the eyes of Oracle) and there is technically no way to step into it.
I’m in a Production Environment . I can’t create/replace a procedure.
I wanna debug script to avoid dbms_output.put_line…