Toad World® Forums

SCRIPT DEBUGGER

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…