QUESTION 85Examine this package:CREATE OR REPLACE PACKAGE pack_curISCURSOR c1 ISSELECT prodidFROM poductORDER BY prodid DESC;PROCEDURE proc1;PROCEDURE proc2;END pack_cur;/CREATE OR REPLACE PACKAGE BODY pack_curISv_prodid NUMBER;PROCEDURE proc1 ISBEGINOPEN C1LOOPFETCH C1 INTO v_prodid;DBMS_OUTPUT.PUT_LINE ( 'Row is: '| | c1%ROWCOUNT); EXIT WHEN c1%ROWCONT >= 3;END LOOP;END procl;PROCEDURE proc2 ISBEGINLOOPFETCH C1 INTO v_prodid;DBMS_OUTPUT.PUT_LINE ( 'Row is: '| | c1%ROWCOUNT); EXIT WHEN c1%ROWCONT >= 6;END LOOP;CLOSE C1;END proc2;END pack_cur;/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.proc1What is the output in your session?
(A)ERROR at line 1:
(B)Row is:Row is:Row is:
(C)Row is: 1Row is: 2Row is: 3
(D)Row is: 4Row is: 5Row is: 6