Oracle plsql Demo-20. Weakly-typed REF CURSOR [no query type specified, and no return type specified]

DeclareType ref_cur_variable isREFcursor;        Cur_variable ref_cur_variable; V_enamevarchar2(Ten); V_deptno Number(2); V_sal Number(7,2); V_sqlvarchar2( -) := 'Select T.ename, T.deptno, t.sal from Scott.emp t';begin    OpenCur_variable forV_sql; LoopFetchcur_variable intoV_ename, V_deptno, v_sal; Exit  whenCur_variable%NotFound; Dbms_output.put_line (cur_variable%RowCount || ' -' ||V_ename||                             '   ' ||V_deptno|| '   ' ||v_sal); EndLoop; Closecur_variable;End;

Oracle plsql Demo-20. Weakly-typed REF CURSOR [no query type specified, and no return type specified]