Re: package limitations

From: Chris Taylor <chris_at_tdl.com> >>
Is there a limit on the size of a Package. <<

Yes there is. I do not know the exact size, but we had a package, around 100K, that when valid code was added to it refused to recompile clean marking the new code in error. I got a hunch, and had the developer comment out another pre-existing part of this long multi-step union and the package recompiled. We broke the package into two packages. The limit is with the resulting compiled code size and not source per se. The version 7 Application Developers Guide did recommend keeping packages to 32K.

It is also possible to have run-time errors if enough free contiguous shared pool is not available to fetch the complete package into when it is invoked. We have gotten a message like 'program module not found' when a large package not in memory was called from Forms. See dbms_shared_pool.keep for helping solve this problem.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue May 05 1998 - 16:48:27 CDT