What is Ref Cursor....

A ref cursor is a variable, defined as a cursor type, which will point to a cursor result.

The advantage that a ref cursor has over a plain cursor is that is can be passed as a variable to a procedure or a function. 

Ref Cursors are of 2 types: 

Weak and 

Strong.