What is the output in your session?

Examine this package:
CREATE OR REPLACE PACKAGE pack_cur
IS
CURSOR c1 IS
SELECT prodid
FROM poduct
ORDER BY prodid DESC;
PROCEDURE proc1;
PROCEDURE proc2;
END pack_cur;
/
CREATE OR REPLACE PACKAGE BODY pack_cur
IS
v_prodid NUMBER;
PROCEDURE proc1 IS
BEGIN
OPEN c1;

LOOP
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE(‘Row is: ‘ || c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 3;
END LOOP;
END proc1;
PROCEDURE proc2 IS
BEGIN
LOOP
FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE(‘Row is: ‘ ||c1%ROWCOUNT);
EXIT WHEN c1%ROWCOUNT >= 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.proc1
What is the output in your session?

A.
ERROR at line 1:

B.
Row is:
Row is:
Row is:

C.
Row is: 1
Row is: 2
Row is: 3

D.
Row is: 4
Row is: 5
Row is: 6

Explanation:
proc1 will open the C1 Cursor and go into a Loop . The Loop Fetches and outputs the first three
records. Since the SET SERVEROUTPUT Command was set the results will be displayed

Incorrect Answers:
A: This procedure will successfully execute with errors.
B: The output will include the Row Number fetched from the cursor.D. This would be the output if
you executed the proc1 cursor fro the second time.