Re: stored package size limitation?

AngeloJS wrote:
>
> Yes,
>
> I am using Oracle 7.1.4 as well, and am an AVID believer in Packages.
> There used to be a 64K limit in Oracle 7.0.16, but Oracle claims that
> that was increased to 100K in Oracle 7.1+. I have hit my head on
> the ceiling with a compiled code size of 78K (sys.dba_object_size).
> Fortunately, it has been easy enough for me to break this down by
> "subclassing" the package.
>
> When I think about it, maybe 64K is enough if you design the packages
> discreetly enough.
>
> Hope this helps,
>
> J. Scott Angelo

I've written a procedure (not a package) which has a code size of 97078. I didn't know there was supposed to be a limit, but maybe I can try to get it to do just a few more things so that I can claim to have broken the limit.

According to sys.dba_object_size, the source size is 82451 and the parsed size is 114838.

The only problem I have come across is that it sometimes fails to compile - I get a memory allocation error. Fortunately, I have DBA access and can issue a 'Alter system flush shared_pool' command, after which it compiles successfully.

Brent Smith Received on Thu Jul 11 1996 - 00:00:00 CEST