How large is the text file? Some versions of Oracle only support <64K of
text.
<Kenneth Koenraadt> wrote in message
news: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 !
> /
>
Received on Tue Jun 18 2002 - 15:09:12 CDT
