PL/SQL Package Standards

From: <cakilner_at_my-deja.com>
Date: Thu, 18 Nov 1999 12:53:58 GMT
Message-ID: <810st5$kvk$1@nnrp1.deja.com>

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 - 06:53:58 CST