O'Reilly logo

Oracle Database 11g PL/SQL Programming by Michael McLaughlin

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 6Functions and Procedures

As you've seen in previous chapters, there are two types of subroutines: functions and procedures. You use these to build database tier libraries to encapsulate application functionality, which is then co-located on the database tier for efficiency.

This chapter covers these areas:

Image Function and procedure architecture

Image Transaction scope

Image Calling subroutines

Functions

Creation options

Pass-by-value functions

Pass-by-reference ...

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