M

Mr. Dubey • 52.30K Points
Coach

Q. Assigning a value to a collection element can cause exceptions, such as

(A) If the subscript is NULL or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must be an integer. Associative arrays can also be declared to have VARCHAR2 subscripts.
(B) If the subscript refers to an uninitialized element, PL/SQL raises SUBSCRIPT_BEYOND_COUNT.
(C) If the collection is atomically null, PL/SQL raises COLLECTION_IS_NULL.
(D) All mentioned above
Correct : Option (D)

Share

Discusssion

Login to discuss.