PLS-00103:遇到符号“CREATE"
这个包有什么问题,因为它给出了错误?
创建或替换包 PKG_SHOW_CUST_DETAILS作为PROCEDURE SHOW_CUST_DETAILS(myArg VARCHAR2);结束 PKG_SHOW_CUST_DETAILS;创建或替换包装主体 PKG_SHOW_CUST_DETAILS作为PROCEDURE SHOW_CUST_DETAILS(myArg VARCHAR2)是开始DBMS_OUTPUT.PUT_LINE(myArg);END SHOW_CUST_DETAILS;结束 PKG_SHOW_CUST_DETAILS;/
在编译上述脚本时,我收到以下错误:
<前>SQL> 显示错误PACKAGE PKG_SHOW_CUST_DETAILS 的错误:行/列错误———————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————-----------------------6/1 PLS-00103:遇到符号CREATE"这个包非常简单,我无法编译它.我搜索了有关此错误消息的早期答案,但没有一个确实解决了我的问题.对于另外 2 个包,我一直收到此错误,无论我做什么,我都被此错误消息所困扰.我什至尝试将所有内容剥离到最低限度,如上所示,但错误消息似乎并没有消失.顺便说一句,我在登录到我的 Oracle 11G 数据库后在命令行 SQL plus 会话上执行此操作.YES- SET SERVEROUTPUT ON -- 已执行,错误信息与此命令无关.
我错过了什么?
解决方案在第 5 行有一个 /
缺失.
;
和 /
之间的区别有一个很好的答案 此处.
基本上,当通过脚本运行 CREATE
块时,您需要使用 /
让 SQLPlus 知道块何时结束,因为一个 PL/SQL 块可以包含许多;
的实例.
What is the problem with this package as it is giving an error?
CREATE OR REPLACE PACKAGE PKG_SHOW_CUST_DETAILS
AS
PROCEDURE SHOW_CUST_DETAILS( myArg VARCHAR2);
END PKG_SHOW_CUST_DETAILS;
CREATE OR REPLACE PACKAGE BODY PKG_SHOW_CUST_DETAILS
AS
PROCEDURE SHOW_CUST_DETAILS(myArg VARCHAR2)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE(myArg);
END SHOW_CUST_DETAILS;
END PKG_SHOW_CUST_DETAILS;
/
On compilation of the above script, I am getting the following errors:
SQL> show errors Errors for PACKAGE PKG_SHOW_CUST_DETAILS: LINE/COL ERROR -------- ----------------------------------------------------------------- 6/1 PLS-00103: Encountered the symbol "CREATE"
The package is very simple and I am not able to compile it. I searched earlier answers on this error message and none of them did solve my problem. I am consistently getting this error for 2 more packages and I am stuck on this error message no matter what I do. I even tried to strip everything to the barest minimum as shown above, but the error message does not seem to go away. BTW I am executing this on command line SQL plus session after logging into my Oracle 11G database. YES- SET SERVEROUTPUT ON -- is executed and the error message has nothing to do with this command.
What am I missing?
解决方案At line 5 there is a /
missing.
There is a good answer on the differences between ;
and /
here.
Basically, when running a CREATE
block via script, you need to use /
to let SQLPlus know when the block ends, since a PL/SQL block can contain many instances of ;
.
相关文章