P.Ravi

• Nov 17th, 2005

 

Extensibility,Modularity, Reusability, Maintainability and one time compilation.

ramya

• Jun 29th, 2007

 

Procedure is used to perform an action.

deviji2000

 Profile Answers by deviji2000 

• Oct 16th, 2007

 

procedures and function hv many benefits in addition to modularizing application development.


1)          easy maintenance  :  sub programs are located in one location and hence it is easy to
             - modify routines online without interfering with other users
             - modify one routine to affect multiple applications
             - modify one routine to eliminate duplicate testing

2)           improved data security & integrity
              controls indirect access to database objects fr non-privileged users with security privileges.  as a subprogram is executed with its definer's right by default, it is easy to restrict the access privilege by granting a privilege only to execute the subprogram to a user.

3)          improved performance

             avoids pl/sql parsing at run time by parsing at compile time

g_sidhu

 Profile 

• Jan 31st, 2008

 

In addition to modularizing application development, stored procedures and functions have the

following benefits:
1) Improved performance

• Avoid reparsing for multiple users by exploiting the shared SQL area
• Avoid PL/SQL parsing at run time by parsing at compile time
•  Reduce the number of calls to the database and decrease network traffic by bundling commands

• Easy maintenance

– Modify routines online without interfering with other users

– Modify one routine to affect multiple applications

– Modify one routine to eliminate duplicate testing

• Improved data security and integrity

– Control indirect access to database objects from nonprivileged users with security

privileges

– Ensure that related actions are performed together, or not at all, by funneling activity for

   related tables through a single path

• Improved code clarity: By using appropriate identifier names to describe the actions of   the routine, you reduce the need for comments and enhance clarity.