使用 Toad 调试 Oracle 存储过程
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1939259/
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
Debug Oracle stored procedure using Toad
提问by CC.
I have the following situation: I have a java code launching a stored procedure. What I want is to launch the java code, and when arriving into the stored procedure, to start debuggin it using Toad.
我有以下情况：我有一个 java 代码启动一个存储过程。我想要的是启动 java 代码，并在到达存储过程时使用 Toad 开始调试它。
Is this possible?
这可能吗？
采纳答案by Peter Lang
I'm afraid it is not possible. The code will be executed in the session of the Java-Code, not in your Toad session.
恐怕这是不可能的。代码将在 Java 代码会话中执行，而不是在您的 Toad 会话中执行。
EDIT:
Writing some trace in your application might be sufficient to track down the problems.
编辑：
在您的应用程序中编写一些跟踪可能足以追踪问题。
TOAD Debugger:
Looks like you need a special license, have a look at asktoadwhich lists the possible reasons if the menu is disabled.
TOAD 调试器：
看起来您需要一个特殊的许可证，请查看asktoad，其中列出了禁用菜单的可能原因。
If your license allows debugging, this articlemight be interesting to allow debugging with Oracle 10.
如果您的许可证允许调试，那么本文可能会对允许使用 Oracle 10 进行调试很有趣。
回答by APC
Oracle offer their own IDE, SQL Developer, which - usually for Oracle - is free. I know you probably don't want to install two IDEs on your desktop but I mention it because it supports debugging of PL/SQL procedures. Find out more.
Oracle 提供他们自己的 IDE SQL Developer，它通常对 Oracle 来说是免费的。我知道您可能不想在桌面上安装两个 IDE，但我提到它是因为它支持调试 PL/SQL 过程。 了解更多。
It is possible to use DBMS_DEBUG by hand but I wouldn't advise it unless you have a lot of time and patience. Oracle intended it as an API for tool vendors rather than something for real people.
可以手动使用 DBMS_DEBUG，但除非您有足够的时间和耐心，否则我不建议您这样做。Oracle 打算将其用作工具供应商的 API，而不是真正的人。
Bear in mind that however you initiate a debugging session you need an account with the DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE privileges.
请记住，无论您如何启动调试会话，您都需要一个具有 DEBUG CONNECT SESSION 和 DEBUG ANY PROCEDURE 权限的帐户。
