琐碎的PL/SQL块会产生令人沮丧的PLS-00103错误 [英] Trivial PL/SQL block generating frustrating PLS-00103 error

问题描述

我可能会有点发疯，但是我一直收到PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following...错误.我已将程序缩减为以下内容:

I may be going a bit insane, but I keep getting a PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following... error. I have pared my program down to the following:

BEGIN
    NULL;
END;
/

我正在AquaData Studio中运行.

Which I am running within AquaData Studio.

这将产生:

• [错误]脚本第1-2行... ORA-06550:第2行，第8列:
• PLS-00103:在预期以下情况之一时遇到符号文件结束"；脚本第2行，语句第2行，第8列

我编写了大量的PL/SQL，通常上述琐碎的代码运行得很好.我的工作到底有什么问题?

I write a decent amount of PL/SQL and normally the above trivial block runs just fine. What the heck is wrong with what I'm doing?

推荐答案

事实证明，该解决方案是@a_horse_with_no_name在他的评论中建议的.在ADS中，您需要打开File→选项 Ctrl + ，(这是逗号！)，然后在常规选项卡上设置以下选项:

It turns out the solution was as suggested by @a_horse_with_no_name in his comment. In ADS, you need to open File → Options Ctrl + , (that's a comma!) and set the following options on the General tab:

• ';'语句分隔符(确保已选中 不 )
行尾终止声明中的
• '/'(确保已选中 )

• ';' Statement separator (make sure it is not ticked)
• '/' at End of Line Terminates Statement (make sure it is ticked)

请参见下面的屏幕截图.做到这一点，一切都有效:

See screenshot below. Do this, and it all works:

这篇关于琐碎的PL/SQL块会产生令人沮丧的PLS-00103错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！