Using Reference Cursors and PL/SQL Stored Procedures

PL/SQL required a look-alike data type for the result set from a SELECT statement to move return sets from one program to another. Oracle developed the system reference cursor data type to meet this need. Reference cursors act as pointers to result sets in query work areas. You use them when you want to query data in one program and process it in another, especially when the two programs are in different programming languages. You have the option of implementing a reference cursor in two ways: one is strongly typed and the other, weakly typed.

A strongly typed reference cursor is explicitly defined by assigning a %ROWTYPE attribute to the cursor. The %ROWTYPE attribute maps the structure from ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

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