SQL & PL/SQL

Hi,

I wanted to find out if it's possible to use a ROWTYPE variable
if I am using a ref cursor, I have tried it with the code below,
but get a compilation error. Can anyone tell if it can be
done?

CREATE OR REPLACE PROCEDURE Ref1(v_EmpFname1 VARCHAR2,
v_EmpLname1 VARCHAR2)
IS
TYPE cv_type IS REF CURSOR;
cv cv_type;
v_FName EMP.FNAME%TYPE;
v_LName EMP.LNAME%TYPE;
v_EmpRow cv%ROWTYPE;
v_LenName INTEGER;
v_StartPos INTEGER;
v_RetPos INTEGER;

BEGIN
-- v_LenName := LENGTH(v_EName);
-- INSTR(v_Ename, v_StartPos, v_RetPos)
OPEN cv FOR
SELECT * FROM EMP WHERE FName = v_EmpFName1 AND LName =
v_EmpLName1;
WHILE cv%FOUND LOOP
FETCH cv INTO v_EmpRow;
DBMS_OUTPUT.PUT_LINE(v_EmpRow.FName);
DBMS_OUTPUT.PUT_LINE(v_EmpRow.LName);
END LOOP;
CLOSE cv;
END;



Thanks in advance.

Sincerely,
Nikhil Kulkarni