SQL> DECLARE
  2                  CURSOR C_Emp
  3                  IS
  4                  SELECT Ename,Deptno FROM Emp WHERE Ename = 'RINTU';
  5          V_Ename Emp.Ename%TYPE;
  6          V_Deptno Emp.Deptno%TYPE;
  7          BEGIN
  8    DBMS_OUTPUT.PUT_LINE('LOOP START');
  9     IF C_Emp%ISOPEN  THEN
 10    close c_emp;
 11    DBMS_OUTPUT.PUT_LINE('CURSOR IS OPEN');
 12    END IF;
 13    IF C_Emp%FOUND THEN
 14    DBMS_OUTPUT.PUT_LINE('cond');
 15          /*FOR I IN C_Emp
 16          LOOP
 17          DBMS_OUTPUT.PUT_LINE(I.Ename || I.Deptno);
 18          END LOOP;*/
 19
 20    ELSE
 21          DBMS_OUTPUT.PUT_LINE('Data not avilable');
 22    END IF;
 23    CLOSE C_Emp;
 24          EXCEPTION
 25          WHEN NO_DATA_FOUND THEN
 26          DBMS_OUTPUT.PUT_LINE('No data found inside the block');
 27          END;
 28  /
DECLARE
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-06512: at line 13