Advantages of pl/sql packages?
Posted by admin on Dec 05 2006
MODULARITY
Lets u encapsulate related items,types,sub programs in a named pl/sql module.
package easy to understand,interfaces between packages simple and clear.Aids application dev
EAISER APPLICATION DESIGN
Can define the spec and compile it first and then later the bady can be dev
INFORMATION HIDING
Packages can specify which items,types and subprograms are PUBLIC(visible and accesible) and PRIVATE(hidden and inaccessible)
ADDED FUNCTIONALITY
Public cursors or types exists till the duration of the session so they can be shared by other sub programs tht execute in that environment.Allows cross transactions without storing in the database.
BETTER PERFORMANCE
Call to a sub program whole package is loaded into memory
so related sub programs require no disc I/O
Leave a Comment