December 2002
Intermediate to advanced
745 pages
17h 26m
English
book
Oracle® Web Application Programming for PL/SQL® Developers
by Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Content preview from Oracle® Web Application Programming for PL/SQL® Developers
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Unit 9.3. Packages
Using Packages
A package is a collection of PL/SQL objects grouped together under one package name. Packages include procedures, functions, cursors, declarations, types, and variables.
The Benefits of Using Packages
There are numerous benefits of using packages as a way to bundle your functions and procedures. A well-designed package is a logical grouping of objects such as functions, procedures, global variables, and cursors. All of the code is loaded on the first call of the package. In a stateful transaction this means that the first call to the package is very expensive (this does not mean it will cost you a lot of money, the expense is in processing of CPU, memory, etc.), but all subsequent calls will result in an improved ...