Re: problem during compiling package

Hi

I am using the oracle package but I never experice this error. But I checked the
oracle 7.3 Sever Messages menual. According to it:

One consequence of the special-purpose design is that the PL/SQL compiler imposes a limit on the block size. The limit dependes on the mix of statements in the PL/SQL block. Blocks that exceed the limit cause this error.

Also Oracle says the best solution is to modularize the preogram by defining subpreograms. I think you can try to reduce the size the stored procedures and functions.

Hope it helps

Xin

Starous <starek_at_pluto.spsselib.hiedu.cz> wrote in article <34F5C4D2.6751650_at_pluto.spsselib.hiedu.cz>...
> Hi all Oracle Gurus
>
> I have problem during compiling package. Package is about
> 1900 lines in length and contains 9 procedures and 6 functions.
> When we try to compile this package body, we get following
> error message.
>
> Line 1: Pos 1: PLS-00123: program too large
>
> Does anybody know, what is wrong ?
>
>
> Little piece of information :
>
> Oracle7 Server Release 7.3.2.3.2 - Production Release
> With the distributed and parallel query options
> PL/SQL Release 2.3.2.3.1 - Production
>
> Happy Oracling and thanks to all who will help me.
>
> Starous
>
Received on Thu Feb 26 1998 - 00:00:00 CST