PLS-00103 Encountered the symbol CREATE

Question

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

User · Answer

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

User · Answer

For me   had to be in a new line  For example create type emp t   didn t work but create type emp t    worked

User · Answer

Run package declaration and body separately

[oracle] PLS-00103: Encountered the symbol "CREATE"

Examples related to oracle

Examples related to pls-00103