This example shows how to use Comosite type
DECLARE CURSOR myEmpCursor IS SELECT empno, ename FROM emp ORDER BY empno; myID emp.empno%TYPE; myName emp.ename%TYPE; BEGIN OPEN myEmpCursor; LOOP FETCH myEmpCursor INTO myID, myName; EXIT WHEN myEmpCursor%NOTFOUND; DBMS_OUTPUT.PUT_LINE(myID||' '||myName); END LOOP; CLOSE myEmpCursor; END;