Declaring a SYS_REFCURSOR Cursor Variable v13
The following is the syntax for declaring a SYS_REFCURSOR cursor variable:
<name> SYS_REFCURSOR;
name is an identifier assigned to the cursor variable.
The following is an example of a SYS_REFCURSOR variable declaration.
DECLARE
emp_refcur SYS_REFCURSOR;
...