Re: PL/SQL Package Standards

Carol,

The only "standards" I'm of which I am aware are the accepted software engineering standards of modularity and encapsulation, which are by no means universally accepted or practiced, but in most cases they should be. I usually group things together which are conveniently thought to form a cohesive set of functions, constants, etc. Anything that's not related to this group doesn't go into the group, but everything that is related does. This is the "art" of software development. Additionally, at one time I worked with a guy who said that he starts breaking his modules into smaller modules when it starts taking too long to compile the monolithic module. This is the practical side of software development that seems to occur during the development cycle, because at the beginning often developers don't completely understand the problem, so the design is formed along the way as the software is transformed into something more substantial. Your solution probably lies somewhere in between these two extremes.

I can say that I've never had this shared memory pool problem you're experiencing, probably because our machines are oversized.

Good luck,

Paul Cluiss
Dallas, Texas

cakilner_at_my-deja.com wrote:

> Does anyone know any standards around developing Packages? It is
> recommended to keep the Packages fairly small? Should everything go into
> packages where possible?
>
> One of the problems I have encountered it we are having a lot of
> problems with space in the shared memory pool. I guess an easy fix
> would be to just bump up the size....but this really isn't an option at
> this point. I do know what a lot of the developers on the system are
> coding using packages and I know one of this is close to 2Meg in
> size...should I recommend we reduce the size of these packages and
> perhaps move some code that it used less frequently into
> procedures/functions that are called from within the package?
>
> Can anyone share any experience in this area?
>
> Thanks,
> Carol Kilner
> ckilner_at_protectair.com
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 18 1999 - 16:30:53 CST