Advantages of using Stored Procedures in Application Development

  1. Application Modularization
  2. Encapsulation of Business Rules and Policies
  3. Access to database objects is both secure & uniform
  4. Network bandwidth conservation
  5. Execution plan retention and reuse
  6. Reduced development cost and increased reliability
  7. Enables sharing of application logic between application
  8. Query Auto-parameterization
  9. Consistent and Safe Data Modificatio