QUESTION 76Examine this package:CREATE OR REPLACE PACKAGE pack_curISCURSOR c1 ISSELECT prodidFROM productORDER BY Prodid DESC;PROCEDURE Proc1;PROCEDURE Proc2;END pack_cur;/CREATE OR REPLACE PACKAGE BODY pack_curISv_prodif NUMBER;PROCEDURE proc1 ISBEGINOPEN C1;LOOPFETCH c1 INTO V_prodid;DBMS_OUTPUT.PUT_LINE('Row is ;'||C1% ROWCOUNT);EXIT WHEN C1% ROWCOUNT>=3;END LOOP;END PROC1;PROCEDURE proc2 ISBEGINLOOPFETCH C1 INTO v_prodid;DBMS_OUTPUT-PUT_LINE ( ' Row is: ' ll c1 %ROWCOUNT); EXIT WHEN C1%ROWCOUNT >= 3;END LOOP;END Procl;/The product table has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session.You execute the procedure PROC1 from SQL *Plus with the command:EXECUTE pack_cur. PROC1;You then execute the procedure PROC2 from SQL *Plus with the command:EXECUTE pack_cur. PROC2;What is the output in your session from the PROC2 procedure?
(A)ERROR at line 1:
(B)Row is:Row is:Rows is:
(C)Row is: 1Row is: 2Row is: 3
(D)Row is: 4Row is: 5Row is: 6