Declaring a SYS_REFCURSOR Cursor Variable v11
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; ...