| |
GeekInterview.com > Interview Questions > Oracle > Basics
| Print | |
Question: What is the different between Stand Alone Procedure and Package?
|
| June 06, 2008 14:02:08 |
#2 |
| amikat |
Member Since: June 2008 Total Comments: 5 |
RE: What is the different between Stand Alone Procedure and Package?
|
Procedure is a named PL/SQL block tht is stored in the database.
Package is a collection of functions and procedures stored within the database.
Pkg consists of 2 parts
1. Specification - declares types,functions,procedures,exceptions,cursors
2. Body - implements the specification
Whenevr a func/proc is referenced from the pkg thn the entire pkg is loaded in the memory so tht whn a diff func from the same pkg is referenced thn its already there in the memory
|
| |
Back To Question | |
