Examine the structure of the PRODUCTS table.
Name Null? Type
———————– ————— —————–
PRODUCT_ID NOT NULL NUMBER(6)
PRODUCT_NAME VARCHAR2(50)
CATEGORY_ID NUMBER(2)
SUPPLIER_ID NUMBER(6)
LIST_PRICE NUMBER(8,2)
View the Exhibit and examine the PL/SQL block.
On execution, the PL/SQL block generates the following error:
ORA-01001: invalid cursor
What could be the reason?
A.
Both the cursor variable arguments should have been passed in IN mode.
B.
The contents of one cursor variable cannot be assigned to another cursor variable using the :=
operator.
C.
The CLOSE statement closes both the cursor variables, therefore the last FETCH statement
cannot execute.
D.
The name of the cursor variables defined and the name of the cursor variables passed as
arguments must be the same.
C