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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
