Why use of package

Could you tell me advantage of using personnalize package in a oracle application? Performance, use of package for library, is there other?

I once read an article (although I can't put my browser on it at the moment) by the great Thomas Kyte about this topic. One of the significant points he brought up was that when you recompile a procedure, it's dependancies become invalidated thereby ensuring an endless recompile nightmare. With packages, you only need to re-compile dependant objects when the package specification changes. As long as the interface to the package (specification) stays the same, you can change the logic (body) all you want without triggering massive recompilation.

here is an example

http://asktom.oracle.com/pls/ask/f?p...7Brecompile%7D

I too recall a similar article:

http://asktom.oracle.com/pls/ask/f?p...D:286816015990

Also, try

http://asktom.oracle.com/pls/ask/f?p...7Brecompile%7D

For additional info.

Hope that helps

Thanks

Austin

That second URL isn't working too well

Go to

http://asktom.oracle.com/pls/ask/f?p...1818834::NO:::

and type

procedure,fn &packages

in the search box try

procedure,fn &packages -- whats the main

That should on return 1 article.

Encapsulation, dependency, other reason why to use package?

From the non-technical perspective, I find it easier to manage a few (reasonably sized) packages rather than many procedures and functions. Configuration management is easier for one thing.

Quote:

---

Originally posted by steeve123
Encapsulation, dependency, other reason why to use package?

---

It is good to logically group your PL/SQL code into packages.

But there a several other reasons: You can pin just one package and thus no neeed to pin all procedures the application uses separately, etc..

I have not read it for a while, but what I remeber on packages, along with dependency explanation already given, You can share variables among functions/procedures in package.

well in a package I think you have global variables for whole package and local variables for each function/procedure