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

You must read
'Some versions of Oracle support only < 64k of *code*' which is quite different

Regards
Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

On Tue, 18 Jun 2002 16:09:12 -0400, "Alan" <alanshein_at_erols.com> wrote:

>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:27:00 CDT