Re: Error PLS-00123 - Program to large

Not quite

Andrew Babb wrote:

> Chris,
>
> Sorry, but up until Oracle8i there has been a limit on the size of PL/SQL
> packages, which Oracle says has been removed in 8i.
>

It's upped to I don't know what, quite large, anyway.

>
> Your only choice prior to 8i is to split the package up.
>

or give it a try on the server side - I recall a max of 32k was imposed by DOS/Windows
programs, plus on te server side, or even svrmgrl may just do the trick. If that doesn;t work, see the above - split...

>
> Andrew
>
> Chris Powell wrote:
>
> > Error PLS-00123 - Program to large appears when trying to compile my
> > package.
> > It appears my 8000 line package is too large.
> > Does any one know of a way to compile a large package without splitting
> > it into smaller units?
> > Can I adjust the compiler block size?
> >
> > --
> > Regards
> >
> > Chris

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046