SQL & PL/SQL

Dear All,

Could you please clarify me on the below ones, What and all differences between a Normal Cursor and a Parameterized Cursor.

CREATE OR REPLACE
  FUNCTION CFN(
      VEMPNO NUMBER)
    RETURN VARCHAR2
  IS
    CURSOR C1
    IS
      SELECT ENAME FROM EMP WHERE EMPNO = VEMPNO;
    vename VARCHAR2(10);
  BEGIN
    OPEN C1;
    LOOP
      FETCH C1 INTO VENAME;
      EXIT
    WHEN C1%NOTFOUND;
    END LOOP;
    RETURN VENAME;
    CLOSE c1;
  END;
  
SELECT cfn(7788) FROM dual;

SQL> set serverout on
SQL> CREATE OR REPLACE
  2    FUNCTION CFN(
  3        VEMPNO NUMBER)
  4      RETURN VARCHAR2
  5    IS
  6      CURSOR C1(vempno NUMBER)
  7      IS
  8        SELECT ENAME FROM EMP WHERE EMPNO = VEMPNO;
  9      vename VARCHAR2(10);
 10    BEGIN
 11      OPEN C1(vempno);
 12      LOOP
 13        FETCH C1 INTO VENAME;
 14        EXIT
 15      WHEN C1%NOTFOUND;
 16      END LOOP;
 17      RETURN VENAME;
 18      CLOSE c1;
 19    END;
 20  /
Function created.
SQL> select cfn(7788) from dual;
CFN(7788)
--------------------------------------------------------------------------------
SCOTT
SQL>

Thanks