Re: PLS-00103: Encountered the symbol "end-of-file"

On Tue, 18 Jun 2002 14:37:36 +0400, "Denis Melnikov" <dmelnik_at_col.ru> wrote:

>Hi,
>I'm trying to run some CREATE OR REPLACE PROCEDURE script. But both
>SQLPlus Worksheet and SQLPlus fail with errors.
>
>Worksheet:
>0/0 PLS-00123: program too large
>
>SQLPlus:
>2273/0 PLS-00103: Encountered the symbol "end-of-file" when expecting
> one of the following:
> ; <an identifier> <a double-quoted delimited-identifier>
> delete exists prior <a single-quoted SQL string>
> The symbol ";" was substituted for "end-of-file" to continue.
>
>Do you have any proposal?
>
>I'm using 8.1.6.3.0 on Intel Solaris 7.
>
>

As the error message friendly suggests, you are probably missing a ";" :

create or replace procedure a is
begin
null;
end <=========== HERE !
/ Received on Tue Jun 18 2002 - 06:59:32 CDT