Advantages of using Stored Procedures in
Application Development
- Application Modularization
- Encapsulation of Business Rules and
Policies
- Access to database objects is both secure
& uniform
- Network bandwidth conservation
- Execution plan retention and reuse
- Reduced development cost and increased
reliability
- Enables sharing of application logic
between application
- Query Auto-parameterization
- Consistent and Safe Data Modificatio