Oracle Sql Dev 中 COMPILE 和 COMPILE WITH DEBUG 的区别?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4624219/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 22:21:45  来源:igfitidea点击:

Difference between COMPILE and COMPILE WITH DEBUG within Oracle Sql Dev?

sqloracledebuggingcompilation

提问by Hiro

I am new to Oracle SQL developer and I was just curious as to the difference between the COMPILE and COMPILE WITH DEBUG options. Does this mean if a program unit is simply COMPILED, then I will not be able to debug it ?

我是 Oracle SQL 开发人员的新手,我只是好奇 COMPILE 和 COMPILE WITH DEBUG 选项之间的区别。这是否意味着如果一个程序单元只是被编译,那么我将无法调试它?

What about in a production environment, where I want to run through the procedure (in debug mode) but without recompiling (in order to avoid invalidating other objects) ?

在生产环境中,我想在其中运行该过程(在调试模式下)但不重新编译(以避免使其他对象无效)呢?

采纳答案by Tim

Does this mean if a program unit is simply COMPILED, then I will not be able to debug it ?

这是否意味着如果一个程序单元只是被编译,那么我将无法调试它?

You're right.

你是对的。

What about in a production environment, where I want to run through the procedure (in debug mode) but without recompiling (in order to avoid invalidating other objects) ?

在生产环境中,我想在其中运行该过程(在调试模式下)但不重新编译(以避免使其他对象无效)呢?

Without recompiling a procedure for debug, debugging is not possible!

不重新编译一个程序进行调试,调试是不可能的!