plsql执行debug

查看文档

You cannot set breakpoints in the PL/SQL block of the Test Script.

也就是说

declare

begin

end;

里面不能加断点

在网上找了解决办法

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.

于是我用

create or replace procedure

然后test sql里面调用该存储过程能进入断点了，

如果出现debug是无法进入该存储过程，请右键存储过程名，"添加调试信息"(add debug information)，

如果出现错误，请在sqlplus 输入show errors查看(plsql dev 创建存储过程出错也不提示。。。)