Exploring Cursor Variables in PL/SQL

Cursor variables (variables declared based on a REF CURSOR type) offer some interesting advantages over "hard-coded" or explicit cursors (CURSOR my_cur IS ...), especially lots of flexibility and the ability to pass a cursor as a parameter or even the return value of a function.

Highlights

01:55 Introduction to cursor variables
02:55 Why use cursor variables?
05:36 Dev Gym use of cursor variables
08:03 Diving into cursor variable syntax and usage
15:15 Q&A: how best to log and propagate exceptions up the stack
23:05 Performance impact of using cursor variables
26:05 Using cursor variables to make dynamic SQL method 4 easier
33:00 Cursor variables and cursor expressions
37:45 More Q&A
39:24 Chris’s experience with cursor variables (before joining Oracle)

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.