使用调试不会在 Oracle SQL Developer 中的断点处停止
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1969342/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Using debug is not stopping on breakpoints in Oracle SQL Developer
提问by uriDium
I am trying to debug a stored procedure using Oracle SQL Developer. The DB is on another box. I have granted privileges using
我正在尝试使用 Oracle SQL Developer 调试存储过程。DB 在另一个盒子上。我已授予使用权限
GRANT debug any procedure, debug connect session TO <user>;
I have placed the break point inside the procedure on one of the assignment lines. I have tried other places too out of desperation. When I click debug I get the debug dialog and I fill in all the values. When I hit debug the stored procedure runs, the debug controls flash across the screen in a second and then it finishes and exits. It misses all the breakpoints as if it weren't even there. Any ideas?
我已将断点放置在程序内的分配行之一上。出于绝望，我也尝试过其他地方。当我单击调试时，我会看到调试对话框并填写所有值。当我点击调试存储过程运行时，调试控件会在一秒钟内在屏幕上闪烁，然后完成并退出。它错过了所有断点，就好像它根本不存在一样。有任何想法吗？
采纳答案by uriDium
Okay, found the answer by accident. Turns out after I altered the proc slightly (added debugs) and the saved then it started working.
好吧，无意中找到了答案。结果是在我稍微改变了 proc（添加了调试）并保存之后它开始工作了。
回答by Falco
For debugging to work you have to compile the Package / Procedure with the Debug-Flag. In SQL-Developer this is done by opening the package and clicking on the little "Gears with a bug"-Button (Compile Package for Debug)
为了调试工作，您必须使用调试标志编译包/过程。在 SQL-Developer 中，这是通过打开包并单击小“带有错误的齿轮”按钮（编译用于调试的包）来完成的
After that all your breakpoints will work.
之后，您的所有断点都将起作用。
