SUBSCRIPTBEYONDCOUNT internal exception - PL/SQL Packages

Q.  Which internal exception is raised when a program references a nested table or varray element using an index number larger than the number of elements in the collection.
- Published on 09 Jul 15

a. NO_DATA_FOUND
b. COLLECTION_IS_NULL
c. SUBSCRIPT_OUTSIDE_LIMIT
d. SUBSCRIPT_BEYOND_COUNT

ANSWER: SUBSCRIPT_BEYOND_COUNT
 
The SUBSCRIPT_BEYOND_COUNT error is where the in-limit of a subscript was greater than that of the count of a varray or was too large for a nested table.

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.)