-
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.
Jeff Hunter
-
-
-
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.
-
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..
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|