Описание тега sys-refcursor

A SYS_REFCURSOR is a predefined cursor variable type. It is weakly defined, meaning that, according to the documentation, it is both more error-prone and more flexible than a strongly defined cursor.

Further Reading:

• Creating Cursor Variables
• Cursor Variable Declaration