O'Reilly logo

Oracle Database Programming using Java and Web Services by Kuassi Mensah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required