Thulasidas

• Nov 27th, 2006

 

Advantages

------------

Modular approach, Encapsulation/hiding of business logic, security, performance improvement, reusability

Disadvantages

-------------

Cant think of any

sunnyjsr

 Profile Answers by sunnyjsr 

• Dec 3rd, 2006

 

Advantages of Packages----------------------------------Modularity,Easier Application Design,Information Hiding,Added Functionality,Better Performance,

Manikandan

• Dec 6th, 2006

 

using we can declare session level(scoped) variables.

since variable declared in pack spec has session scope.

deepserp

• Dec 9th, 2006

 

Disadvantages of Package - More memory may be required on the Oracle database server when using Oracle PL/SQL packages as the whole package is loaded into memory as soon as any object in the package is accessed.

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 6th, 2007

 

we cant pass parameters to packages

MZ

• Mar 6th, 2007

 

Disadvantages: Updating one of the functions/procedures will invalid other objects which use different functions/procedures since whole package is needed to be compiled.

jagadeesh9

 Profile Answers by jagadeesh9 Questions by jagadeesh9

• Feb 24th, 2008

 

Package: It is an collection of related variables, cursors,procedures and functions stored at one location. They supports OOPS features like function over loading, encapsulation.
ADV:
       We can reduce the I/O operations.
       Multiple interaction with database.
       They improve performance while accessing sub-programs from remote client.


They are stored permanentely in USER_SOURCE system table.

binurajnair

 Profile Answers by binurajnair 

• Aug 2nd, 2008

 

We can overload functions/procedures inside packages.