Re: Stored Procedure VS Package

From: Bert Scalzo <bscalzo01_at_7-11.com>
Date: Wed, 7 Apr 1999 10:37:02 -0500
Message-ID: <7eftvj$k1$1@news.ses.cio.eds.com>

I think your confusion lies with the performance advatage packages offer over stad-alone procedures/functions.

Say you have functions A and B, and that A calls B. If they are stand alone functions. Then database loads A when it's executed, then later it loads B when A's code refers to it. Hence, 2 IO's.

Packages load all their procedures at once. So if A and B are placed in the same package, then executing A loads B by default. So only 1 IO...

Bert Scalzo
DBA
EDS Received on Wed Apr 07 1999 - 10:37:02 CDT