如何获取有关Oracle/TOAD中的编译错误的信息 [英] How to get information about compile error in Oracle/TOAD

问题描述

我正在使用TOAD在Oracle数据库中开发存储功能.当我单击TOAD中的以脚本方式运行"按钮时，它告诉我该脚本执行时出现0个错误和1个编译错误.在哪里可以看到特定的编译错误.我对TOAD相当陌生，因此我可能会在界面上缺少一些明显的东西，例如用于查看此类错误消息的选项卡/窗口.

I'm using TOAD to develop a stored function in an Oracle database. When I click the "run as script" button in TOAD, it tells me that the script was executed with 0 errors and 1 compile errors. Where do I see the specific compile error(s). I'm fairly new to TOAD so I might be missing something obvious about the interface like a tab/window to see such error messages.

推荐答案

您可以在脚本的末尾添加SHOW ERRORS，这会将错误消息打印到脚本输出"选项卡上，或者进行编译使用Toad中的执行语句"命令执行该函数，这将导致错误显示在编辑器底部的框中​​.

You can either add SHOW ERRORS to the end of the script, which will print the error message(s) to the "script output" tab, or compile the function using the "Execute Statement" command in Toad, which will cause the errors to be displayed in a box at the bottom of the editor.

这篇关于如何获取有关Oracle/TOAD中的编译错误的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！