为什么debbuger不会在oracle SQL开发人员中启动？ [英] Why won't the debbuger launch in oracle SQL developer?
问题描述
大家好，
我在许多不同的网站上搜索我遇到的问题后来到这里。
我在Oracle数据库中有这个庞大的程序，我需要调试才能找到错误。
在Oracle SQL开发人员中打开该过程后，我单击齿轮图标，然后立即编译以进行调试。然后我只需点击bug图标即可开始调试。
在SQl开发者屏幕的右下方会出现一个启动栏，但没有其他任何事情发生。在连接部分，您可以在其中看到过程，表等列表...在我尝试调试的过程名称前面出现一个绿色箭头。似乎它正准备开始调试，但实际上它从未开始。
我尝试过：
- 我已经重新启动了oracle服务器。
- 我试图调试许多其他程序，所有程序都有相同的行为。
- 如果我点击运行按钮，设置参数并运行程序，它将运行，并给我输出变量。
- 程序编译没有错误。
- 除了调试外，一切似乎都正常工作。
Hello Everybody,
I have come here after searching in many different websites for a problem like the one I am facing.
I have this huge procedure in an Oracle Database which I need to debug to find an error.
After opening the procedure in Oracle SQL developer, I click on the gear icon, and "compile for debug" right after. Then I just click in the bug icon to start debugging.
On the bottom right of SQl developer screen appears a launching bar, but nothing else happens. In the connections section, where you can see the list of procedures, tables, etc... a green arrow appears before the name of the procedure I am trying to debug. It seems like it is preparing to start debugging, but it actually never starts.
What I have tried:
- I have restarted the oracle server.
- I have tried to debug many others procedures, all of them have the same behavior.
- If I click on the "run" button, set the parameters and run the procedure, it will run, and give me the output variable.
- The procedure compiles without errors.
- Everything seems to be working just normal, except for debugging.
推荐答案
PL / SQL开发人员？您是否右键单击该过程并选择在编译后添加调试信息？如果没有调试信息，您的存储过程将在您尝试调试时运行，但会直接压缩它。我的猜测。
PL/SQL developer? Did you right click on the procedure and select add debugging info after compiling? Without debugging info, your stored proc will run when you try to debug but will zip right through it. My guess.
嘿大家，
我感谢你的帮助。
我可以解决更改监听器配置的问题。
奇怪的是，除调试器外，一切正常。
谢谢！
Hey everybody,
I appreciate your help.
I could solve the problem by changing the listener configuration.
Weird thing is that everything was working just fine, except for the debugger.
Thanks!
这篇关于为什么debbuger不会在oracle SQL开发人员中启动？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
