CREATE OR REPLACE PROCEDURE REFCUR(L_P_EMPNO IN EMP.EMPNO%TYPE) IS
TYPE EmpCurTyp IS REF CURSOR;
L_REFCURSOR_CHECK EmpCurTyp;
L_V_SQL_STRING VARCHAR2(200);
v_ename emp.ename%TYPE;
v_dname dept.dname%TYPE;
BEGIN
L_V_SQL_STRING := ‘SELECT E.ENAME, D.DNAME… 72 more words