PL/SQL exceptions of assigning a value to a collection

Q.  Assigning a value to a collection element can cause exceptions, such as
- Published on 08 Jul 15

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

ANSWER: All mentioned above

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲