What are the advantages of having a Package ?

Increased  functionality  (for  example,global  package  variables  can  be declared  and  used  by  any proecdure in the package) and performance (for example  all  objects  of  the package are parsed compiled, and loaded into memory once)
  • Interview Candidate
  • 5
  • 2330

Showing Answers 1 - 5 of 5 Answers

J Lehew

  • Aug 25th, 2005
 

A package allows grouping of similar procedures. This is extremely important when working on a system with 500 stored procs. Also it allows some procedures to be made public and private and common variables and structures can be defined at the package level instead of inside each procedure.

  Was this answer useful?  Yes

Pankaj Gauba

  • Sep 13th, 2006
 

Main advantage is OVERLOADING of function and procedures

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions