Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PLS-00103: Encountered the symbol "end-of-file"

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

From: Denis Melnikov <dmelnik_at_col.ru>
Date: Wed, 19 Jun 2002 10:03:56 +0400
Message-ID: <aep6p6$148m$1@storm.comstar.ru>


<Kenneth Koenraadt> сообщил в новостях
следующее:3d0f391a.25737929_at_news.capgemini.se...
> On Tue, 18 Jun 2002 17:42:44 +0400, "Denis Melnikov" <dmelnik_at_col.ru>
> wrote:
>
> ><Kenneth Koenraadt> сообщил в новостях
> >следующее:3d0f2012.19330565_at_news.capgemini.se...
> >> 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 !
> >> /
> >
> >Unfortunately, it is not the case.
> >
> >
>
> Please post the full procedure.
>
> - Kenneth Koenraadt

I'm not sure it is useful because of size >100K. I tried to cut some text, when size dropped below 100K, procedure created successfully (not workable, sure).

Denis Received on Wed Jun 19 2002 - 01:03:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US