SQL Language Guide : 7. Database Procedures, Sessions, and Events : How Database Procedures Are Created, Invoked, and Executed : Benefits of Database Procedures
 
Share this page                  
Benefits of Database Procedures
Database procedures provide the following benefits:
Enhanced performance
Reduced amount of communication between an application and the DBMS Server. The DBMS Server retains the query execution plan for a database procedure, reducing execution time.
Control over access to data. The DBA can use the GRANT statement to enable a user to execute a procedure even if the user does not have permission to directly access the tables referenced in the procedure.
Reusability and reduced coding time. The same procedure can be used in many applications.