Re: What is PL/SQL Packages?
From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 22 Jul 2003 07:26:13 -0700
Message-ID: <3722db.0307220626.45dd69dd_at_posting.google.com>
Date: 22 Jul 2003 07:26:13 -0700
Message-ID: <3722db.0307220626.45dd69dd_at_posting.google.com>
Packages are useful because:
- they encapsulate everything (that needs to be)
- they use memory very efficiently (the whole package stays resident in memory after being called the first time).
- If the implementation changes (but not the spec), the calling programs don't need to be recompiled.
- public variables and cursors survive the whole session, which is often very useful (they can then be reused all over again through the session).
Daniel Received on Tue Jul 22 2003 - 16:26:13 CEST