0Just run these two blocks individually, observe the output and comment on what do you understand from it.
SET SERVEROUTPUT ON
Declare
Cursor C is select * from emp;
i c%rowtype;
Begin
Fetch C into i;
End;
SET SERVEROUTPUT ON
Declare
Cursor C is select * from emp;
i c%rowtype;
Begin
Fetch C into i;
Exception
WHen others Then
DBMS_OUTPUT.put_line('Error MSG: '||Substr(SQLERRM,1,30)||' And Error Code: '||SQLCODE);
End;
And lastly, focus on this statement in the output- 'PL/SQL procedure successfully completed.'
