October 2022
Intermediate to advanced
380 pages
9h 35m
English
The real antipattern in this chapter is not the use of stored procedures. The antipattern is to use any technology feature—stored procedures is just a good example—because it was done before you. Just because stored procedures were right in some prior project doesn’t necessarily make it a good choice for your current project.
Stored procedures (or more broadly, stored routines, which also includes functions, triggers, and packages) are a traditional part of application development if you use one of the major commercial SQL database platforms such as Oracle, Microsoft SQL Server, IBM DB2, Informix, or Sybase. However, there are several hidden costs to using stored procedures.
Despite the fact ...