Declaring a User Defined REF CURSOR Type Variable v13

You must perform two distinct declaration steps in order to use a user defined REF CURSOR variable:

• Create a referenced cursor TYPE
• Declare the actual cursor variable based on that TYPE

The syntax for creating a user defined REF CURSOR type is as follows:

TYPE <cursor_type_name> IS REF CURSOR [RETURN <return_type>];

The following is an example of a cursor variable declaration.

DECLARE
    TYPE emp_cur_type IS REF CURSOR RETURN emp%ROWTYPE;
    my_rec emp_cur_type;
        ...