RE: Stand alone Procedure v/s Package Procedure

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: Harvinder.Singh_at_MetraTech.com

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: ListGuru_at_fatcity.com (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: NDATFM_at_labor.state.ny.us

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: ListGuru_at_fatcity.com (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).