Advantages of pl/sql packages?
Posted by silpa on Mar 25 2007
Advantages of pl/sql packages are:
1.MODULARITY
Lets u encapsulate related items,types,sub programs in a named pl/sql module.
Makes package easy to understand and interfaces between packages simple and clear.Aids application dev
2.EAISER APPLICATION DESIGN
Can define the spec and compile it first and then later the bady can be dev
3.INFORMATION HIDING
Packages can specify which items,types and subprograms are PUBLIC(visible and accesible) and PRIVATE(hidden and inaccessible)
4.ADDED FUNCTIONALITY
Public cursors or types exists till the duration of the session so they can be shared by other sub programs that execute in that environment.Allows cross transactions without storing in the database.
5.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