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:
Function and procedure architecture
Transaction scope
Calling subroutines
Functions
Creation options
Pass-by-value functions
Pass-by-reference ...
Get Oracle Database 11g PL/SQL Programming now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.