August 2002
Intermediate to advanced
528 pages
10h 12m
English
This chapter covers some advanced PL/SQL topics that are particularly of interest to the developer. I include coverage of these topics primarily to have more extensive coverage of PL/SQL. Power users sometimes request or attempt this functionality. When they have trouble, they will contact their first line of support: the data administrator or IT developer.
The first topic is cursor variables, which allow a procedure to pass a result set to a calling object. I have occasionally used cursor variables in an Oracle form and report. The second topic completes the coverage of objects first discussed in Chapter 3. This section discusses how to use PL/SQL to extract object attributes from the database. The final topic ...