Question: type refcursor is ref cursor?
Answer: There are two forms of ref Cursor the strong REF CURSOR and the weak REF CURSOR. PL/SQL is a statically typed language, and the weak REF CURSOR is one of the few dynamically typed constructs supported. When you defined a SYS_REFCURSOR is a predefined weak REF CURSOR type.