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


Creation options

Pass-by-value functions

Pass-by-reference ...

Get Oracle Database 11g PL/SQL Programming now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.