Declaring a SYS_REFCURSOR cursor variable v17
The following is the syntax for declaring a SYS_REFCURSOR
cursor variable:
<name> SYS_REFCURSOR;
Where name
is an identifier assigned to the cursor variable.
This example shows a SYS_REFCURSOR
variable declaration:
DECLARE emp_refcur SYS_REFCURSOR; ...