Ref Cursor

A ref cursor variable is not a cursor, but a variable that points to a cursor. A ref cursor allows you to store the results of a 'bulk collect' from a table into PL/SQL table and then reference the array with the ref cursor as a pointer.