Adventages of package over standalone procedure

What are the advantages of packages over standalone procedure ?

Showing Answers 1 - 8 of 8 Answers

Shiva gupta

  • Nov 25th, 2014

In package we simultaneously create multiple procedure , function as well as cursor . In one program we create all of these but in procedure we cant create function and cursor.


  • Dec 19th, 2014

Package is a collection of procedures, functions and cursors. advantages of packages . all the global variable will be loaded in memory. whereas in procedure it is not

Hema nagaraju

  • Dec 19th, 2014

Packages are collection of functions,procedures,subprograms and cursors.packages improve the performance of application by executing all at once.

With package all the related & dependent methods will be grouped. When ever a method is called from the package all the related methods will be activated in memory. So we can find a small improvement in performance of the application.

  Was this answer useful?  Yes


  • Dec 29th, 2014

package is a collection of functions,procedures and cursors so that we can perform multiple tasks at a time.


  • Jan 4th, 2015

packages will be pre-compiled components, will improve performance compare to standalone one.

abhijit musale

  • Feb 18th, 2015

you can wrap/encrypt the package code .

  Was this answer useful?  Yes

Habib Ali

  • May 9th, 2016

Packages can be cached inside the SGA, resulting in faster execution than a normal stored procedure.

  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