SCRIPT DEBUGGER

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.