Harvinder,
In my humble way of thinking, I would develop a single Oracle package to
perform "a transaction", or to contain a group or procedures that might be
used by other packages.
For example, lets say you are developing a college registration application.
You might create one package that contains all procedures to create a
student demographic record, including name, address, emergency contact info
etc. Another package might contain all procedures needed to maintain the
college catalog, with another package to contain procedures to register a
student for a course.
It's all a matter of application design and organization. This is not to
say that singular stored procedures are a bad thing. A robust application
will have a mix of packages, procedures and functions.
The trade-off of packages vs procedures is SGA size. Remember, these things
sit in memory for awhile after they have been used. The larger the package,
the more memory issues you need to manage (like pinning package in memory at
db startup to make sure they are available, and to make sure they have room
to fit).
anybody else have comments for Harvinder?
hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Thursday, July 05, 2001 6:21 PM
To: Multiple recipients of list ORACLE-L
> Hi,
>
> What are the advantages/disadvantages of using procedures in a package as
> compare to stand alone procedures in application.
>
> Thanks
> Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
