CODEWITHSUNDEEP
oracle-databaseplsqltoad
Revious
Revious

Reputation: 8146

Toad for Oracle: using script debugger to debug anonymous block

It simply doesn't work. I cannot set breakpoint and SHIFT + F7 runs to the end.

Is it possible to debug them?

Upvotes: 0

Views: 3739

Answers (1)

Bob Jarvis - Слава Україні
Bob Jarvis - Слава Україні

Reputation: 50017

I suspect this is similar to the issue in PL/SQL Developer where a breakpoint can't be set in a test window. If you dive into DBMS_DEBUG a bit you'll see that to set a breakpoint the caller needs to provide namespace, name (of the program unit), owner, database link (!), and line number. Thus it appears that code which is not compiled into the database can't have a breakpoint set on it. My solution is to put the anonymous block I want to debug into a procedure and then call that procedure from the test window.

Share and enjoy.

Upvotes: 2

Related Questions