Chapter 1. Stored Procedures as Database Programming Model
Although stored procedures have been around for more than a decade now, there still is a recurrent, almost ideological, debate on this programming model. Although it takes position in favor of stored procedures, the intent of this book is not to fuel this discussion but to elaborate on the benefits, assuming that there are situations where stored procedures are the right design choices. In this chapter, I will discuss the rationales for stored procedures, the obstacles to their adoption, languages used for writing stored procedures, and proprietary procedural languages such as PL/SQL versus open standards languages such as Java.
Rationale for Stored Procedures
As database developers and ...