What could be the reason?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *