DECLARE
CURSOR AHMED IS SELECT ENAME,SAL
FROM EMP;
EMP_REC EMP%ROWTYPE;
BEGIN
OPEN AHMED;
LOOP
FETCH AHMED INTO EMP_REC;
EXIT WHEN AHMED%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(EMP_REC.ENAME||'+++++++++'||EMP_REC.SAL);
END LOOP;
CLOSE AHMED;
END;
/

الخطأ فى جملة EMP_REC EMP%ROWTYPE;

DECLARE
CURSOR AHMED IS SELECT ENAME,SAL
FROM EMP;
EMP_REC AHMED%ROWTYPE;
BEGIN
OPEN AHMED;
LOOP
FETCH AHMED INTO EMP_REC;
EXIT WHEN AHMED%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(EMP_REC.ENAME||'+++++++++'||EMP_REC.SAL);
END LOOP;
CLOSE AHMED;
END;

...............................................

احسنتم ... شكرا لكم