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;/

在编译上述脚本时，我收到以下错误:

这个包非常简单，我无法编译它.我搜索了有关此错误消息的早期答案，但没有一个确实解决了我的问题.对于另外 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 ;.

这篇关于PLS-00103:遇到符号“CREATE"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！